Explainry Tutorials to Expert in IT

REPT function in Excel

The REPT function repeats a text string by a specified number of times.


1– The function mentioned below repeats the text string three number of times.





text – a text string needs to be repeated.

number_times – The text to be repeated in a number of times.

Important Notes

  • The REPT function returns an empty cell if numer_times is ‘0’.
  • If number_times is not an integer e.g. 9.8, excel will consider it ‘9’ and will repeat the specified text ‘9’ number of times.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved