The RIGHT Function
The RIGHT function returns a given text from the left of our text string based on the number of characters specified.
Syntax:
RIGHT(text, [num_chars])
Parameters:
- Text: The text we want to extract from.
- Num_chars (Optional): The number of characters you want to extract. Default num_chars is 1 and the number must be a positive number that is greater than zero.
Example:
Step 1: Format your data.
Now if you want to get the last geeks from “w3wiki” in B2. Let us follow the next step.
Step 2: We will enter =RIGHT(B2,5) in the B3 cell. Here we want Excel to extract the last 5 characters from the right side of our text in B2.
This will return “geeks”.
Excel String Functions – LEFT, RIGHT, MID, LEN, and FIND
Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text data.
- LEFT
- RIGHT
- MID
- LEN
- FIND