what is the left and right function in excel?
The Excel LEFT function extracts a given number of characters from the left side of a supplied text string. For example, LEFT("apple",3) returns "app". ... text - The text from which to extract characters. num_chars - [optional] The number of characters to extract, starting on the left side of text.