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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
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
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.
ASKER
thanks all
=SUBSTITUTE(A1," ","")