I recently inherited a database with contact information. There seem to be loads of hidden formatting, like tabs, carraige returns, spaces, etc., which I can't see when I export to an Excel spreedsheet, and some of which I can see when viewing individual records. But, there are over 5,000 records and I can't go through them one by one.
Is there any fast way to clean up the data?
All the best,