LEFT Function Explained
The LEFT function in Microsoft Excel returns the leftmost characters from a text string, based on the number of characters specified. It takes two arguments: text (the text string from which the leftmost characters are to be returned) and num_chars (the number of characters to be returned).
LEFT Function Syntax
LEFT(text, [num_chars])
- text: The text string from which the leftmost characters are returned.
- num_chars: [optional] The number of characters to return from the leftmost position in the text string.