Left Right Mid Formula in excel with example- Excel Free Learn
How to use Left Right Mid Function in excel:-
There is some data in CELL B6.
B6=123.369.852
With this we can separate the data according to our needs. In This Picture you can practice.
LEFT FORMULA USE :-
In the LEFT FORMULA, we select the cell reference, and how much value we want, we have to fill it in the formula.
=LEFT(B6,3)
MID FORMULA USE:-
In the MID FORMULA we select the cell reference, from where to where we want to pick up. We have to give this information to the formula.
=MID(B6,5,3)
RIGHT FORMULA USE:-
RIGHT FORMULA also shows the result like LEFT FORMULA, in this we have to tell how many numbers of right have to be picked.
=RIGHT(B6,3)
CONCLUSION:-
In this we learned how we can use the most easy and common formula of TEXT FUNCTION.
No comments:
Post a Comment