How to Remove All White Spaces to the Right of a Word in Excel

1. Launch Microsoft Excel 2010. Open your spreadsheet by choosing 'Open...' from the 'File' menu or pressing and holding 'Control' ('Command' for Mac) and then pressing 'O.' Navigate to your Excel spreadsheet file and either double-click its name or click on it once and press the 'Open' button.
2. Click on the header of the first column of cells that contains text you need to edit. Go to the 'Home' tab and choose the 'Cells' group. Click on the arrow alongside 'Insert.' Click on 'Insert Sheet Columns' to create a new column to the left of the column you selected.
3. Click in the first cell of the column you just inserted. Type an equal sign and then the letter 'T.' Scroll down the list of functions that comes up till you reach 'Trim' and click on it. Click on the first cell in the column you need to edit. Your cell contents should say '=TRIM([cellnumber]),' where [cellnumber] is the column/row reference to the first cell you need to edit. Press 'Enter' to confirm your formula.
4. Click in the cell in which you just added the 'TRIM' function and place your pointing device cursor at the bottom right corner of the cell. Your cursor will change from an outlined plus sign to a black plus sign. Pull down on the lower right corner of the cell until you drag down to the bottom of the column of data from which you need to remove extra spaces. Let go of the pointing device when you have dragged all the way down. The data column you inserted should be filled with the same information that's in the original column to its right, but without the extra spaces.