Removing space in a cell

[LaserDance]

Hi, folks.

How can I cut space in a cell ? For instance in A1 I have ZW34 00 76, I want it to be
ZW340076.

Any help?

[arthurbr]

If data is in A6 try =SUBSTITUTE(A6," ","")

Or for a 1 shot Ctrl -H replace (space) with (nothing)

[Kimberly@TM]

I would just try a simple Find-Replace. Select the cells you want to do this in and then Find (Space) and replace with nothing. I have a similar situation to this and use this method all the time with success.

[Charlie_Howell]

try this...i'm sure it's gonna work for you.