REPT Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

REPT is an Excel Text function. Repeats a piece of text a set number of times.

REPT syntax

=REPT(text, number_times)

REPT is used to clean up and reshape text data pulled from other systems before reporting on it.

Open the live Excel-style spreadsheet and try REPT yourself. No Excel install or sign-up needed to start.

What does the REPT function do in Excel?

Repeats a piece of text a set number of times.

What is the syntax of REPT in Excel?

The syntax is =REPT(text, number_times). text: The text to work with; number_times: How many times to repeat the text.

Where can I practice REPT online for free?

Open the free live spreadsheet on Cellgrids and try REPT yourself. No Excel install is needed and you can start without signing up.