Skip to main content

LEFTPAD

Use the LEFTPAD function to left-pad the text with the specified character a given number of times.

Use

LEFTPAD( text, character, times )
Left pad the text with the given character a number of times.

ParameterRequiredDescription
textYesthe text to pad
characterYesthe character to use to left pad
timesYesthe number of times to insert the character

ReturnsText

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

ON THIS PAGE