Edit

Share via


PADLEFT ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The PADLEFT function returns a String value of the specified length, where the start of the specified string is padded with the specified characters.

Syntax

PADLEFT (text, length, padding chars)

Arguments

text: String

A String value that represents the original text.

length: Integer

An Integer value that represents the final number of characters in the padded string.

padding chars: String

The characters to use for padding.

Return values

String

The resulting text value.

Example

PADLEFT ("1234", 10, " ") returns the text string "      1234".

Additional resources

Text functions