Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

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.

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.

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.