How To Use RIGHT Function | Microsoft Excel

Right Function will return the specified character from the reference string from the right side.

Syntax of RIGHT Function

=RIGHT(text,[num_chars])

text: It is a string or text which you want to extract
num_char: how much character you want in return

Behavior of RIGHT Function

You have a broad data and you just want to retrieve only some characters of the column at that time this function comes to action.
Here we have taken five names. And I want only last 5 letters of names so here I have used a right function.
If you do not describe that how much characters you want in return, a RIGHT function will return only last character of the string.
This function returns me last five characters of the names.

Usage of RIGHT Function

To get a limited character from long strings(text)

Return of RIGHT Function

RIGHT will return a small part of the string from the right side of string(text)

How would you like this content to write us in the comment box!

If you face any difficulty in the content feel free to ask!

Thank You.