RIGHT Function - Excel
Overview
The RIGHT function in Excel is a useful tool for extracting a specified number of characters from the end (right side) of a text string.
Example:
=RIGHT("Elephant", 3)
Syntax:
=RIGHT(text, num_chars)
text: This is the text string from which you want to extract characters.
num_chars: This is the number of characters you want to extract from the right side of the text.
Example
In this example, the RIGHT function returns the value “king” because we plugged in the word “Hiking” into the function and selected that we only wanted to pull 4 characters from the right side.
