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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

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,109,453
Messages
5,528,856
Members
409,840
Latest member
priyanshu270
Top