7 ways to use Excel REPT function

7 ways to use Excel REPT function

1 July 2017

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.