delete single spaces

[Guest]

How can i delete a single space from a cell example 123 456, to 123456
I see the trim option and clean but does not do this simple? task
Please help someone , Mark

 

[Guest]

Hi Mark:

Pull-down:

Edit > Find and click the Replace tab

Enter a single space in the find what field and enter nothing in the replace
field.

The touch replace all

 

[Guest]

=SUBSTITUTE(A1," ","")
Regards,
Stefi


„Mark R†ezt írta:

 

[Guest]

Thanks Stefi Have a good Day

=SUBSTITUTE(A1," ","")
Regards,
Stefi


„Mark R†ezt írta:

 

[Guest]

You are welcome!
Stefi


„Mark R†ezt írta:

 

[Guest]

If the spaces in your document are "nonbreaking" spaces (you can't see them
in Excel), you will need to:
Select data (columns, rows, etc. where you want to remove ALL spaces.
CTRL+H {Find what?} ALT+0160 (use Numpad numbers)
{Replace with} [leave blank]
Replace all.
Search remainder of document? NO