Although REPT can repeat numbers as well as text, the result from REPT is always atext value.

REPT can be used topad values to a certain lengthor to build asimple in-cell histogram.

To pad numeric values with zeros, acustom number formatmay be a better option.

Excel formula: Extract word that begins with specific character

The REPT function appears in more advanced formulas thatsolve some tricky problems.

See below for more examples.

When the text is not found, FIND returns a #VALUE error.

Excel formula: Get last word

For example =REPLACE(“XYZ123”,4,3,“456”) returns “XYZ456”.

Excel formula: Count cells that contain n characters

Excel formula: Extract word containing specific text

Excel formula: Split text with delimiter

Excel formula: Get last line in cell

Excel formula: Pad a number with zeros

Excel formula: Pad text to equal length

Excel formula: Convert inches to feet and inches

Excel formula: Last row in text data

Excel formula: Basic in cell histogram

Excel formula: Extract multiple lines from a cell

Excel formula: Extract nth word from text string

Excel formula: Conditional message with REPT function

Article image

Excel FIND function

Excel REPLACE function