FILL

Returns a string of a specified length that repeats the specified string.

Syntax

FILL(String, Length)

String is the string to repeat. Length is the length of the resulting string. The first argument must be a string or formula resulting in a string. The second argument must be a positive non-zero integer or formula resulting in a positive non-zero integer.

Examples

This example returns '/////':

FILL('/', 5)

This example returns 'xyxyx':

FILL('xy', 5)