Left and Right Function in Excel
Do you ever felt the need of fetching several characters or digits from a string in particular cell?
Excel provides us quick and easy functions to fetch characters from left,right by using LEFT and RIGHT function.
LEFT Function:
Syntax:
=LEFT(text,[num_chars])
Left function includes two arguments:
- TEXT: In this argument we have to fill the cell reference.
- NUMCHARS: In this argument we have to write the number of characters we want to extract from the left.
Let us understand Left function with the help of an example :
By writing the left formula like this we will get the first five that is first name from left of the string and the result will be as shown below :-
RIGHT Function:
Syntax:
=RIGHT(text,[num_chars]
Right function also includes two arguments:
- TEXT: In this argument we have to fill the cell reference.
- NUMCHARS: In this argument we have to write the number of characters we want to extract from the right.
Let us understand Right function with the help of an example:
By writing right formula like this we will get the last five that is last name from right of the string and result will be as shown below: