Why To Use Left Function in Microsoft Excel? The Left function is used to get first N characters from the given text string or the text contained in a cell. Syntax of LEFT Function in Excel LEFT(Text, Number_of_characters) For example, the function LEFT("Normal",3) will return Nor. Syntax of LEFT function with Cell Reference LEFT(CellReference, Number_of_characters) For example, let the cell A2 contains the text Humanity , the function LEFT(A2,5) will return Human . Similarly if Cll A12 contains "England" then Left(A12,5) will give "Engla" that is first five characters of contents of cell A12 from left side. How To Implement LEFT Function in Excel Uses of Excel Functions Left Right in Excel Worksheet First of all place the cursor in an empty cell next to cell A2, to enter the function. Type = Type the function name LEFT Type the left parenthesis ( Type A2 from keyboard. Type , (that is Comma) Type 5 so that the first 5
Study and Download Perfect Computer Notes on Concepts of Information Technology and Computer Science.