The RIGHT function in Microsoft Excel is a powerful function for extracting text from a cell. It returns a specified number of characters from the end of a string of text. This makes it easy to pull specific information from the end of a long string of text.
For example, RIGHT can extract the domain name from a longer email address. The function takes two arguments, the text string and the number of characters to return. The RIGHT formula is often combined with other text functions, such as LEFT, MID, and FIND, to extract more complex strings of text.