Question: what is the return value of right function in excel?
Answer: The RIGHT function in Excel returns the specified number of characters from the end of a text string. Where: Text (required) - the text string from which you want to extract characters. Num_chars (optional) - the number of characters to extract, starting from the rightmost character.