Excel LEFT function


The Excel LEFT function returns a specified number of characters from the start (left) of a text string.


=LEFT(text, [num_chars])

Arguments (inputs)

text = the text string

num_chars = [optional] the number of characters to return from the start (left) of the string (if blank, the default is 1 character)

Return value

The LEFT function returns a text string with the specified number of characters as defined by the num_chars. If the num_chars is left blank, then 1 character will be returned.


Excel LEFT function example

In the example above the LEFT function returns two characters, defined by num_char = 2, from the text in cell F6, “Graduate”.

=LEFT(F6, 2)

The result returned is “Gr”.