REPT

Syntax:

REPT ( string , replication-count )

Description: Creates a string that is replication-count number of occurrences of string concatenated together.

Arguments:

Name

Type

Description

string

text

Designate the string to be replicated.

replication-count

number

The number of times string is to be replicated, truncated to integer. If replication-count is 0, the resulting string is empty.

Return Type and Value: text – The final replicated string.

However, if replication-count < 0, #VALUE! is returned.

example: