REPT or repeat can save time when typing a large string of numbers.
Example:
Rather than typing “—————————-”
use the formula =REPT(”-”,20) (formula displays “-” 20 times)
This YouTube clip shows REPT function being used to create an instant bar chart. It’s a pretty cool idea. Since the repeat function is limited to 32,767 characters, you may need to divide by 100,000 to compare customer revenue. To compare % you could multiple by 100. Watch the 1:33 minute video to see how easy REPT is to use.
If you liked my post, feel free to subscribe to my rss feeds
Any advice given on this blog is my own opinion and not that of anybody else. That said - any advice taken from this blog is at your own risk. 
BlogoSquare