In Excel, string functions let you retrieve specific characters, also called a substring, from a source string. There are several string functions: LEFT() : Gets characters from the left side of ...

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.