Help Help Help Help!!!!!

[stapleton2308]

Hi,

If i have data which in one cell which looks like below:

ABC 0001
DDS 0002
HHH 0003
EEI 0004

(each of these has once space between the letters and numbers)

How can i combine it, so the cells now looks like:

ABC0001
DDS0002
HHH0003
EEI0004

Help would be much appreciated

Thanks

 

[Kinjalip]

Hey, you can select the column, then go to Edit>Replace. Then on the Replace
tab place a space in the "Find what:" area then select Replace ALL. This will
remove all of the spaces.

Hope this helps

 

[Bob Umlas, Excel MVP]

in a parallel column (assuming your data starts in A1):
=SUBSTITUTE(A1," ","")
and fill down. Then copy this new range, select A1, Edit/Paste Special,
click Values & OK.
Lastly, clear the formulas justg created.
HTH
Bob Umlas
Excel MVP

 

[Bob Umlas, Excel MVP]

My bad. Jeffrey L. Lippard's solution is easier! Duh!