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.

Overview of REGEX Functions Excel’s new REGEX functions include two powerful tools: REGEXEXTRACT: This function allows users to extract specific text based on predefined patterns.

This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.