Uses and explanation
of "LEFT" & “ RIGHT Formulas.
Formula: A: "RIGHT” B: “LEFT”
=RIGHT(Text,[num_chars])
Explanation: RIGHT formula is used to split the value inside the cell. In a cell we have a name like "John Abraham", but we don't need the full name, as per client requirement, we want only last name from the tab. In this case, we can use Right formula in MS Excel.
Example: Let suppose we have the name “Mark Henry” in a cell A:1. We would
like to take only “Henry” from the
cell. See below, how can we pull the last name by the RIGHT formula.
=RIGHT ( E9 , 6 )
You can see in the above table that we can separate Hanery name with using RIGHT formula.
Name: Mark Hanery.
Query: We want to separate the last name only.
Formula = Right(E9,6)
Result: Hanery
E9 is the cell reference and 6 is the number of letters that we want to separate from the name.
If we have huge data or small data we can use right formula in both cases. We can get fast and easy result.
B: “LEFT”
=LEFT(Text,[num_chars])Explanation: Use of LEFT formula is also to split the value inside the cell.
Example: Now suppose we have the same name “Mark Hanery” in a cell A:1. We have to take only first name, which is “Mark” from the cell. See below, how can we pull the first name by LEFT formula.
=LEFT( E9 , 4 )
The image with the example is given above is enough to understand the logic as well as the syntax of the formula. See the small table in the image, where we are separating the first name from the full name. It is very simple, use Formula "Left", select the value and put the last digits you want, like in the example we took 4 last digits.
Name: Mark Hanery.
Query: We want to separate the first name only.
Formula = Left(E9,4)
Result: Mark
Where E:9 is the cell reference and 4 is the number of letters that we want to get separate.
Please leave your comment: for more excel queries.
Thanks for your time.
Comments
Post a Comment