Edit

Share via


LEFT 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 LEFT function returns a String value that presents the specified number of characters from the start of the specified string.

Syntax

LEFT (text, number)

Arguments

text: String

A String value that represents the original text.

number: Integer

The number of characters that must be returned from the start of the original text.

Return values

String

The resulting text value.

Example

LEFT ("Sample", 3) returns "Sam".

Additional resources

Text functions