removing a single space in a cell
 

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

removing a single space in a cell
 

=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

removing a single space in a cell
 

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



Jarek Kujawa wrote:

=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

--

Dave Peterson

removing a single space in a cell
 

you won, Dave
;-)
of course SUBSTITUTE
sorry

On 8 Maj, 13:44, Dave Peterson wrote:
I bet Jarek meant:
=substitute(a1," ","")

Jarek Kujawa wrote:

=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

--

Dave Peterson

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

Cheer!