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