Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.