Excel finally speaks Regex, and it cleans the data I used to fix by hand

Imagine you need to extract a simple number from a complex string, such as a product code with region-specific abbreviations or a column of phone numbers stored in four different formats. To make matters worse, because the data came from an external source, it might also contain trailing spaces, inconsistent formatting, or other small errors.

Läs hela artikeln hos källan.