Removing these leading spaces – or trailing spaces that fall at the end of a cell's contents – requires an Excel function. Click in the first cell of a blank column on your spreadsheet.

Finding and removing blank spaces and rows in Excel is easy and can be done by using the "Find & Select" feature. Here's how to delete blank rows in Excel on a Mac or PC.

Excel will then delete the blank cells from the selected data range. The blank cells in rows 7 and 10 are gone. (Screenshot: TechRepublic) SEE: Learn how to parse time values in Microsoft Excel.

If you wish to impart your Excel Spreadsheet a clean look, delete or remove the extra blank cells, rows, spaces, columns, from Excel sheet.

To remove spaces between characters and numbers in the above example, we may use the Find and Replace feature in Excel as follows: Select the data range. Click on the Find & Select dropdown in the ...