Remove Trailing Spaces In Excel

How to clean leading and trailing spaces.

Remove trailing spaces in excel. So you can type the following formula in cell b1 then press enter key. Select the range you want to remove all trailing spaces from cells then click kutools text remove spaces. If you need to strip leading and trailing spaces from text in one or more cells you can use the trim function. Trim a1 then select cell b1 and drag the autofill handle down to other cells that you want to remove the leading or trailing spaces.

Substitute c9 char 160 step 2. Trim substitute c9 char 160 now all of your leading and trailing spaces are cleaned up. Trim b3 once you ve removed extra spaces you can copy the cells with formulas and paste special elsewhere as values to get the final text. In the example show the formula in cell c3 is.

The goal is to replace the non breaking spaces with normal spaces. Select a cell next to the cell you want to remove extra spaces from string type this formula. Press enter key to get the result then drag auto fill handle over the cells you want to remove extra spaces from all of leading spaces and trailing spaces and extra spaces have been removed.