RIGHT

The RIGHT formula is used to extract a specified number of characters from the end of a cell. To use the RIGHT formula, select the cell where you want the result to appear and enter “=RIGHT(” followed by the cell you want to extract characters from and the number of characters you want to extract. For example, “=RIGHT(A1,3)” would extract the last three characters from cell A1.

Example:

Extract the last three characters from cell A1: =RIGHT(A1,3).