removing a single space in a cell

[birdsting]

I offen encounter a problem to remove a single space either
numeric/characters in a single cell manully at excel. e.g: 123 456 or
to day.

Please help me how to do it with thanks.

birdsting

 

[Jarek Kujawa]

=REPLACE(A1," ","")

 

[Dave Peterson]

I bet Jarek meant:
=substitute(a1," ","")

=REPLACE(A1," ","")

 

[Jarek Kujawa]

you won, Dave
;-)
of course SUBSTITUTE
sorry

I bet Jarek meant:
=substitute(a1," ","")

 

[birdsting]

thanks a lot to solve this problem with a simply function which I drop
it off.

Cheer!