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.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.