Easy Explanation Notes with Examples

REPT function in Excel

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

Example

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

Result:

Syntax

=REPT(text,number_times)

where,

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 - 2019 Explainry.com | All Rights Reserved