View Single Post
 
Old 06-16-2016, 01:33 PM
jhato160 jhato160 is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2016
Posts: 13
jhato160 is on a distinguished road
Default Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work

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
Reply With Quote