Formulas > =REPT()
How to Use REPT() in Google Sheets
Description
How To Actually Use REPT() in Sheets
REPT(text_to_repeat, number_of_repetitions)
Try REPT yourself
In cells A1:A5, enter any text you want. In cells B1:B5, use the REPT formula to repeat the text in column A three times. Your formula should be in B1 and dragged down to B5.
Hints (3)
-
Remember to reference the cell in column A for the text.
-
Use the number 3 as the second argument in the REPT function.
-
Make sure to drag down the formula from B1 to B5.
Sheet art with CHAR and REPT
Combine REPT with CHAR to build progress bars, star ratings, and other in-cell visuals in Google Sheets.
- Progress bar formulas (copy-paste REPT bars)
- Star rating formulas
- Writing tracker formulas
- Browse all visual formulas
Sheet art examples with REPT()
10 copy-paste formulas from the Playground use REPT(). Click a card to copy the full formula into Google Sheets. Showing a curated set from 1154 matching examples.
=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))
████████░░
=REPT("█",MIN(5,MAX(0,ROUND(A1*5/100,0))))&REPT("░",5-MIN(5,MAX(0,ROUND(A1*5/100,0))))&" "&A1&"%"
███░░ 60%
=TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0")&" "&REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))
24,891/50,000 █████░░░░
=REPT("🟢",MIN(A1,B1))&REPT("⚪",MAX(0,B1-A1))
🟢🟢🟢🟢🟢⚪⚪⚪⚪⚪
=REPT("🧱",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))
🧱🧱🧱🧱🧱░░░░░
=REPT("🟥",MIN(A1,1))&REPT("🟧",MIN(MAX(0,A1-1),1))&REPT("🟨",MIN(MAX(0,A1-2),1))&REPT("🟩",MIN(MAX(0,A1-3),1))&REPT("🟦",MIN(MAX(0,A1-4),1))&REPT("🟪",MIN(MAX(0,A1-5),1))&REPT("⬜",MAX(0,B1-A1))
🟥🟧🟨🟩🟦🟪
=REPT("★",MIN(A1,B1))&REPT("☆",MAX(0,B1-A1))
★★★☆☆
=REPT("●",MOD(NOW()*86400,4))&REPT("○",4-MOD(NOW()*86400,4))
●●○○
="Round "&A1&"/"&B1&" "&REPT("🔄",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))
Round 2/4 🔄🔄○○
=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))
██████░░░░
5 Better Sheets Tutorials
Create a Sheet of Sheets for Project Management and/or Data Management
Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
COUNT()
INDIRECT()
REPT()
SPLIT()
TRANSPOSE()
Build a Thermometer for Savings Goals
Track your goals with a thermometer.
CONCATENATE()
IF()
REPT()
ROUND()
SPLIT()
+1 more
Memento Mori | The Death Dashboard
In this tutorial I go from raw data to a full formed dashboard. In this particular case we're looking at the number of weeks someone might have left to live. A bit of stoic motivation, part baroque style. You'll see how I look for inspiration in the Memento Mori medallion and also in images representative of "Memento Mori" then I use those colors in the images to make this dashboard.
In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.
In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.
REPT()
Create a Course Outline in Google Sheets
Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.
CONCAT()
CONCATENATE()
COUNTA()
COUNTIF()
IF()
+4 more
Pick a Raffle Winner with Number of Tickets
Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
ARRAYFORMULA()
IF()
INDEX()
JOIN()
RANDBETWEEN()
+3 more
Learn more about the REPT() formula:
Generate a REPT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses REPT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a REPT() formula