Excel REPT function
Repeats a text the number of times you choose. In Spanish Excel it is called REPETIR.
Syntax
English Excel
=REPT(text, number_times)
Spanish Excel (Mexico)
=REPETIR(texto, núm_de_veces)
Spanish Excel (Spain, Latin America)
=REPETIR(texto; núm_de_veces)
| Argument | What it is |
|---|---|
| text | The text or symbol to repeat. |
| number_times | How many times; decimals are dropped. |
Example
REPT(text, times) repeats a text. With a symbol like ■ and sales divided by 1000, it draws a bar on each row without making a chart.
=REPT("■",B2/1000)
Common mistake
REPT("■",B2/1000) draws a bar inside the cell, a chart without a chart.
About Ads
This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.
Ads help us keep WebHerramientas free for everyone
Practice REPT
Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons
In-cell chart with REPT
REPT(text, times) repeats a text. With a symbol like ■ and sales divided by 1000, it draws a bar on each row without making a chart.
In C2, repeat the symbol ■ once for every 1000 in sales.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Sales | Bar | |
| 2 | January | 4,200 | ||
| 3 | February | 6,800 | ||
| 4 | March | 3,100 | ||
| 5 | April | 9,400 | ||
| 6 | May | 7,500 | ||
| 7 |
Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.
Frequently asked questions
- What is REPT called in Spanish?
- In Spanish Excel it is REPETIR. The formula =REPT("■",B2/1000) is written =REPETIR("■";B2/1000) (or with commas in Mexico).
- Why does REPT use semicolons in some Excel versions?
- It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
- What is the most common REPT mistake?
- REPT("■",B2/1000) draws a bar inside the cell, a chart without a chart.