LEFT function

Category: Text functions

What does this function do?

Returns characters to the left of a string according to the number of characters specified.

Syntax:

LEFT(text, [num_chars])

• text (required): The text string that contains the characters you want to extract
• num_chars (optional): specifies the number of characters you want to extract. It must be greater than or equal to zero, if num_chars is greater than the length of text, LEFT returns all of text, if num_chars is omitted, it is assumed to be 1.

Examples:

=LEFT("Excel",2)= "Ex"