Cleaning downloaded data

johnybb

New Member
Joined
Sep 15, 2014
Messages
2
Hello,
in my spreadsheet I have some downloaded data but it has a lot of blank spaces and gaps, that make it impossible to work with. I've tried TRIM formula but it is not working.
Anybody has an idea what to do with this one? It's too big to do it manually.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

mretyk

New Member
Joined
May 6, 2014
Messages
4
If TRIM is not working maybe you should try CLEAN - it should remove first 32 nonprinting characters in ASCII.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,443
Messages
5,547,955
Members
410,820
Latest member
Prepost
Top