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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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,084
Messages
5,545,863
Members
410,711
Latest member
Josh324
Top