LEFT Function

Returns the leftmost characters from a text string.
Sample Usage
LEFT("Hello World!", 3)
Syntax
LEFT(
  • text
  • [
    num_chars
    ]
)
  • text
    —
    The text that you want to return a portion from.
  • num_chars
    —[optional]
    Starting from the leftmost character, the number of characters to return. If a number isn’t provided, only the first character is returned.
Usage Notes
  • With right-to-left languages, LEFT will return the rightmost characters instead.
Related Functions
RIGHT
MID
FIND
REPLACE
JOIN
Was this article helpful?
YesNo