Returns a substring beginning at the start of a given string.


Left(string, number)

string (required) The string from which a left substring will be returned.

number (required) The desired length of the returned substring.


Left("Dec. 12, 1950", 3)
  • Returns “Dec”
Left("St. Louis", 20)
  • Returns “St. Louis”
  • If number is greater than the length of string, the result is the original string.
Left("San Francisco", -5)
  • Returns “San Fran”
  • If you use a negative number, the result is the string with that number of characters removed from the end.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us