Table of Contents
LEFT function in Excel returns the given number of characters from the left side of a text string.
Extract characters from the left side of a string.
text – data from which characters are to be extracted.
num_chars – number of characters to be extracted. default value is 1.
Number formatting is not a part of the text data. So, LEFT function will ignore $, % or any other characters displayed in cells using Number formatting in Excel.