The Excel RIGHT function returns one or more character, based on the specified number of characters from the end of a supplied text string.
- text – The text string from which characters to be extracted from the right side.
- [num_chars] – An optional argument that specifies the number of characters to extract on the right side. In case omitted, 1 is considered as the default value.
Useful Additional Notes:
- When text argument is supplied as numbers, function extracts number of digits as well
- The returned output from numbers remains in text string only.
- Number formatting will not be a part of original value therefore will not be counted and returned.
- Function returns #VALUE! error if supplied number of character is less than 0.
Examples – RIGHT Function:
Example 1: Extracting rightmost character from text given in cell B8
In the following example, only mandatory argument is provided which is referring to text given in cell B8 therefore RIGHT has extracted the rightmost character from the supplied text, since the default value is considered as 1 for num_chars argument when it is skipped.
Example 2 & 3: Extracting 5 number of characters from the right side of the text string
In the second example, when we supplied 5 in the second argument after supplying the text argument, RIGHT function extracted 5 characters on the right side.
But in the third example, when numerical string supplied in first argument and we told function to extract 5 [num_chars], RIGHT returned with 5 digits from the end of the string however, the answer returned in text format only.
Similarly, we can make a good use of RIGHT function with other Excel functions and features of Excel depending on users’ need.
LEFT | SUBSTITUTE | FIND | SEARCH