In this article:

How to Use the REPT Function in Google Sheets (2024 Guide)

May 8, 2024

Google Sheets REPT Function Explained

The REPT function in Google Sheets is a powerful yet simple tool that allows you to repeat text a specific number of times. It's particularly useful for creating visual effects, filling in cells with repeated characters, or even generating simple patterns.

REPT(text_to_repeat, number_of_repetitions)


  • text_to_repeat: This is the text or value you want to repeat.
  • number_of_repetitions: This is the number of times you want the text to be repeated. This must be a positive number.

How to Use the REPT Function in Google Sheets

Follow the steps below to use the REPT function in Google Sheets.

Step 1: Select a Cell

Click on the cell where you want the repeated text to appear.

Step 2: Enter the REPT Function

Type = followed by REPT to start the function. Google Sheets will help by showing you a tooltip with the function's syntax.

rept google sheets

Step 3: Add Your Text and Repetition Number

Within the parentheses, add the text you want to repeat in quotation marks, followed by a comma, and then the number of times you want it repeated.

After you've entered your text and repetition number, press Enter. The cell will now display your text repeated the number of times you specified.

For example, if you want to repeat the word "Hello" 5 times, you would write:

=REPT(" Hello ", 5)

google sheets rept


Let's say you're creating a progress report and want to use a simple bar chart made of repeated characters (e.g., "|") to visually represent progress. You can use the REPT function like this:

A1: Task 1

B1: =REPT("|", 30) 

google sheets rept function

This cell will show "|" repeated 30 times.

We hope that this article has helped you and given you a better understanding of how to use the REPT function in Google Sheets. If you enjoyed this article, you might also like our articles on how to remove formulas in Google Sheets and how to make a sales tracker in google sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->