REPT

TextExcel 2007

Repeat a text string a number of times.

Syntax

REPT(text, number_times)

Examples

=REPT("■", 7)

→ ■■■■■■■ — An in-cell bar chart.

=RIGHT(REPT("0", 6) & A2, 6)

→ Pad a number to 6 digits.

Related functions

TEXT CONCAT

More Text functions

ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.