next up previous contents index
Next: REPLACE, XLREPLACE Up: A. Function Reference Previous: REGEX   Contents   Index


REPEAT, REPT

Syntax: REPEAT(S, N)
  REPT(S, N)

S = a string value
N = a numeric value

REPEAT returns the string S repeated N times.

REPT is a synonym for REPEAT.

Examples:

Z1 = ``There's no place like home.''

REPEAT(Z1, 1) = ``There's no place like home.''

REPT(Z1, 3) = ``There's no place like home.There's no place like home.There's no place like home.''

REPEAT(Z1, 0) = `` ''

Excel function: REPT


next up previous contents index
Next: REPLACE, XLREPLACE Up: A. Function Reference Previous: REGEX   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003