REPT Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Repeats text a given number of times.

REPT (text, number_times)

Parameters

Name

Required/Optional

Data Type

Description

text

Required

String

The text you want to repeat.

number_times

Required

Number

A positive number specifying the number of times to repeat text.

If number_times is:

  • Zero (0), REPT returns "" (empty text).

  • Not an interger, it is truncated.

REPT ("*", 5)

Returns *****.

Show: