remove spaces in a cell

[ROLG]

how to i remove the spaces between numbers within a cell?

1 2 3 4 change to 1234

thankyou for everyone help

 

[Debra Dalgleish]

Select the cell
Choose Edit>Replace
In the 'Find What' box, type a space
Leave the 'Replace With' box empty
Click 'Replace All'
Click OK to confirm the replacement
Click Close

 

[Dave Peterson]

Be careful with this one <vbg>.

If you only have one cell selected and you only wanted to change that one cell,
the edit|replace will work against the whole worksheet.

ctrl-click on another cell (empty or with no spaces) and then do it and it'll
work.

(Welcome to my other world!)

 

[Debra Dalgleish]

Thanks! Excellent advice.

I'll have to check the real estate prices here.

Be careful with this one <vbg>.

If you only have one cell selected and you only wanted to change that one cell,
the edit|replace will work against the whole worksheet.

ctrl-click on another cell (empty or with no spaces) and then do it and it'll
work.

(Welcome to my other world!)

 

[RagDyer]

Did you click "Replace" or "ReplaceAll" ?

"Replace" just works on the *one* selected cell for me.
"ReplaceAll" does do the *entire* sheet, even though only one cell was
selected.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Be careful with this one <vbg>.

If you only have one cell selected and you only wanted to change that one
cell,
the edit|replace will work against the whole worksheet.

ctrl-click on another cell (empty or with no spaces) and then do it and
it'll
work.

(Welcome to my other world!)

 

[Dave Peterson]

I followed Deb's instructions that said Replace All.

hehehe.

But I wasn't smart enough to even try the single replace.

 

[RagDyeR]

AAahhhh ! ! !... the power of a woman's suggestion.<g>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I followed Deb's instructions that said Replace All.

hehehe.

But I wasn't smart enough to even try the single replace.

 

[Dave Peterson]

And my ability to overlook the single replace button!