Returns a substring from the beginning of a specified string.

Sample Usage


LEFT("lorem ipsum")


LEFT(string, [number_of_characters])

  • string - The string from which the left portion will be returned.

  • number_of_characters - [ OPTIONAL - 1 by default ] - The number of characters to return from the left side ofstring.


  • 0 is a valid input for number_of_characters and will cause LEFT to return the empty string.

See Also

SUBSTITUTE: Replaces existing text with new text in a string.

SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

RIGHT: Returns a substring from the end of a specified string.

MID: Returns a segment of a string.

In order to use the LEFT formula, start with your edited Excellentable:

Then type in the LEFT formula in the area you would like to display the outcome:

By adding the values you would like to calculate the LEFT formula for, Excellentable will generate the outcome:



User does not have sufficient privileges to access this Content
Learn More