barenose

Cleaning out the dross

Discussion created by barenose on Apr 2, 2014
Latest reply on Apr 2, 2014 by Stephen Huston

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,

 

JB

Outcomes