how to erase all spaces in text cell?

D

D

With TRIM function it is possible to erase only double spaces but I need to
erase all spaces in a text cell.
Do I have to use VBA funaction?
Tnx in advance.
 
M

Miguel Zapico

You can use a combination of CLEAN and SUBSTITUTE, something like:
=CLEAN(SUBSTITUTE(A1," ",CHAR(13)))

Hope this helps,
Miguel.
 
A

aidan.heritage

use the edit replace command and replace a single space with nothing at
all.
 
D

D

It helped.
Tnx

Miguel Zapico said:
You can use a combination of CLEAN and SUBSTITUTE, something like:
=CLEAN(SUBSTITUTE(A1," ",CHAR(13)))

Hope this helps,
Miguel.
Click to expand...
 
Top