=REPLACE(A1," ","")


On 8 Maj, 05:23, birdsting wrote:
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

--
birdsting