[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
REPT ( string , replication-count )
Description: Creates a string that is replication-count number of occurrences of string concatenated together.
Arguments:
|
Name |
Type |
Description |
|
string |
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:
REPT("ABC",3) results in ABCABCABC
LEN(REPT("ABC",0)) results in 0
end example]