Link to home
Start Free TrialLog in
Avatar of HuiShi
HuiShi

asked on

How to get rid of spaces between commans in csv file

Hi there:
   I have a csv file which contains the following data

1,2323,32323,545,343
2,23,,   , ,  ,,,
3, 3,4  , , ,,

Is that possible to get rid of those spaces between commas?

thanks

Hui
ASKER CERTIFIED SOLUTION
Avatar of ajarvey
ajarvey
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If your data is in cell A1 then u can use this formula to remove spaces:

=SUBSTITUTE(A1," ","")
Ajavey is correct... If all your data is numeric and you want to eliminate ALL spaces, replace " " with ""; you're essentially telling the computer to take out all spaces, anywhere in that file... save it, and viola!
Avatar of Chris Bottomley
Often in a CSV file the spaces are in fact hard spaces so it could also be worth replacing them ..

replace hard space with blank i.e.

HArd space is alt key & 0160 on the number pad then release alt key.
for blank make sure you delete all the data replace with box.

Chris
Just do it through notepad like I've suggested and save yourself a TON of hassle. What I've laid out is the absolute least confusing, and will definitely work.
Avatar of HuiShi
HuiShi

ASKER

thanks all