delete single spaces
 

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

delete single spaces
 

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
--
Gary''s Student


"Mark R" wrote:

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

delete single spaces
 

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


€žMark R€� ezt Ã*rta:

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

delete single spaces
 

Thanks Stefi Have a good Day

"Stefi" wrote:

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


€žMark R€� ezt Ã*rta:

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

delete single spaces
 

You are welcome!
Stefi


€žMark R€� ezt Ã*rta:

Thanks Stefi Have a good Day

"Stefi" wrote:

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


€žMark R€� ezt Ã*rta:

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

delete single spaces
 

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

"Mark R" wrote:

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