Please see attached video. I am outsourcing data entry and need to "scrub" my data to have a clean excel file to use for organizing data and uploading to google earth. A lot of the data I am getting leaves excess space in the cells causing it to wrap or expand the cell. Please advise if there is a way to handle this aside from going in and deleting spaces from each cell. I have many thousands of rows of date. TRIM doesn't work.
I have also thought about text to columns as a solution to clean everything up.
I appreciate the input.
http://www.screencast.com/t/OE5rzQXYk