7 ways to use Excel REPT function

When is the last time you used the REPT function in Excel? REPT is one of Excel's little-known, overlooked and underutilized functions, yet it is very useful.

Here are 7 ways you can start using the REPT function:

• Add leading zeros.
• Create inline charts.
• Replace nested IF.
• Create a mirror chart.
• Create stem and leaf plots.
• Extract N words from a text string.
• Create a star rating system.