Returns the leftmost characters from a text string.
LEFT("Hello World!", 3)
- 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.
- With right-to-left languages, LEFT will return the rightmost characters instead.