Help Help Help Help!!!!!

S

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
 
K

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
 
B

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
 
Top