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
|