The RIGHT function in Excel is a text function that allows you to extract a specified number of characters from the right side of a text string. It can be used to manipulate text data in various ways, such as extracting file extensions or extracting last names from full names.
Syntax
=RIGHT(text, [num_chars])
Arguments
text - the text string from which you want to extract characters
num_chars - the number of characters you want to extract