Open your spreadsheet in Microsoft Excel 2003 and double-click the cell in which you want the textual white space to appear. Press the "Spacebar" to enter single-character spaces.

6] Shift the Excel cell down with Insert Copied Cells Select a range of cell, right-click and select Copy . Click the location that you want the data to go, then click the Home tab.

Click on the first cell in a column of text that you want to clean up. For example, suppose cell A1 contains the text "Feed hungry cats " and its three trailing blank spaces.

Place your cursor on cell C5 and type the following function: =TRIM(A5) The above function will remove all unwanted spaces from the text string in cell A5 and display the result in cell C5.