These 3 new Excel functions ended a decade of my complicated text-cleaning formulas

A vendor export landed in my inbox with phone numbers in four different formats, customer names stored last-first, and order IDs, where five of twelve rows broke the house format. I'd already swapped out the older Excel functions that still turn up in most workbooks, and this is the same move one layer down.

via MakeUseOf https://ift.tt/Mw1WQjK