Help Help Help Help!!!!!
 

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


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=512680

Help Help Help Help!!!!!
 

Hey, you can select the column, then go to EditReplace. 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
--
Jeffrey L. Lippard, A+ certified, CHDP certified


"stapleton2308" wrote:


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


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=512680

Help Help Help Help!!!!!
 

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

"stapleton2308" wrote:


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


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=512680

Help Help Help Help!!!!!
 

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

"Bob Umlas, Excel MVP" wrote:

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

"stapleton2308" wrote:


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


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=512680