REPT

Repeat text as specified

Sponsored Link

REPT
Purpose 
Repeat text as specified
Return value 
The repeated text.
Syntax 
=REPT (text, number_times)
Arguments 
  • text - The text to repeat.
  • number_times - The number of times to repeat text.
Usage notes 

Use the REPT function to repeat text a given number of times. This can be useful if you want to fill a cell, or pad values to a certain length.

It's possible to build a basic histogram chart using REPT, by translating values directly into a certain number of (repeated) characters.

Sponsored Link

0 votes. 0 / 5