Question: what is the right formula in excel?
Answer: The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT("apple",3) returns "ple". One or more characters. text - The text from which to extract characters on the right.