Excel spreadsheet applications and tips
How to delete all spaces in a selection (or how
to delete spaces in a sheet)?
Easiest way to replace spaces in a selection or within a sheet is by the 'Find and Replace' dialogue box.
Step 1 - Open 'Find and Replace' dialogue box by pressing 'Control + H'. In the 'Find What' box enter a space. Leave the 'Replace With' box as blank. Now select 'Replace All'.
Step 2 - Excel deletes all spaces within the selected area.
How to remove blank cells