Ben Richardson checks out a new function:
Instead of building up a few different text functions on top of each other, you can now use regex inside Excel formulas to search for patterns, and clean data much more efficiently.
Our favourite of these new additions is REGEXREPLACE, which lets you find text based on patterns and replace data in one simple formula.
Read on to see how the REGEXREPLACE() function works.