I'm sure you can do that 'natively' in Excel, but not my field of expertise; IIRC I actually spent longer faffing about in the Excel docs looking for a way to do this (and failing) than writing the awk regexes.

It did make me wonder how often some variant of this happens every day. "Data entry" is still a job, after all...