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: