Description:
Pad a string to the specified length with another string added on the left.
Syntax:
pad(s,c,l)
Note:
The function pads string s to a new length of l by continuously adding characters of string c to the left side.
Parameter:
|
s |
A string expression |
|
c |
A string expression |
|
l |
A number or an expression whose result is the numeric value |
Option:
|
@r |
Pad to the right side of a string, to a new length |
Return value:
String
Example:
|
|
A |
|
|
1 |
=pad("Soth","Miss",10) |
The return value is "MissMiSoth". |
|
2 |
=pad@r("Soth","er",8) |
The return value is "Sotherer". |