Separating Uppercase Words with Regex

There is an Excel file that teaches how to perform the Separating Uppercase Words with Regex operation.

Excel Spreadsheet for Separating Uppercase Words with Regex

This file automatically separates fully uppercase words from mixed-case name lists. Additionally, it uses the REGEXREPLACE function to perform the operation without requiring a helper column. Thus, a single formula written in one cell dynamically spills both rightward and downward. However, it not only extracts uppercase words but also presents the remaining names in a separate column. Therefore, it provides a practical solution for quickly splitting mixed name data.

Hope it is useful.