Now, let’s use Excel’s RIGHT () function to extract the last two characters from each value. To do so, enter = RIGHT([@Department],2) into H3 and copy to the remaining cells.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.