The RIGHT function is used to extract a specific number of characters from the end of a cell.
This can be useful to when needing to remove unwanted characters in a cell that appear on the left of the cells content. This can happen as a result of importing data into Excel from another application or database.
The syntax for the RIGHT function is:
=RIGHT(text, [num_chars])
Argument | Purpose |
---|---|
Text | The data containing the characters you want to extract |
Num_chars | The number of characters you want to extractIf omitted, it extracts only the last character |
The example below shows the RIGHT function being used to extract the last 4 characters from the content of cell A1.