This Excel tutorial explains how to use the Excel REPT function with syntax and examples.
The Microsoft Excel REPT function returns a repeated text value a specified number of times.
The syntax for the Microsoft Excel REPT function is:
REPT( text, number )
The REPT function can be used in the following versions of Microsoft Excel:
The REPT function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel REPT function examples and explore how to use the REPT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following REPT examples would return:
=REPT(A1, 3) Result: "abcdabcdabcd" =REPT(A2, 2) Result: "isis" =REPT("apples", 2) Result: "applesapples"
(scroll to see more)