delete single spaces

M

Mark R

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
 
G

Gary''s Student

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
 
P

PlayingToAudienceOfOne

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
 
Top