Excel Right Function

The RIGHT function in Excel is used to extract a specified number of characters from the right side of a text string. Here's the basic 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 end (right side) of the text string.

For example, if you have a text string "Hello, World!" in cell A1 and you want to extract the last 5 characters, you would use:

Right Formula used in B3

Next