Funzione di Google Sheets

REPT

Repeats a given text string a specified number of times.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

REPT(text, number_times)

The REPT function allows you to fill a cell with a repeated character or string. It is commonly used to create simple in-cell data visualizations, such as progress bars or star ratings.

Argomenti

textobbligatorioThe text string you want to repeat.
number_timesobbligatorioA positive number specifying how many times to repeat the text.

Esempi

=REPT("-", 5)

Risultato: -----

Repeats the hyphen character five times.

=REPT("★", 3)

Risultato: ★★★

Repeats the star symbol three times to create a rating visual.

Domande frequenti

What happens if number_times is 0?

The function will return an empty string.

Can I use REPT with numbers?

Yes, but the number will be treated as text and repeated as a string.

Funzioni correlate

CONCATENATE TEXT LEN