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.

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.

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.

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.

To split the cells, start by selecting the merged cells on the sheet. Next, navigate to the Alignment group in the ribbon of the Home tab. Click the down arrow next to the Merge and Center button and ...