Remove Trailing Spaces In Excel

Select the range you want to remove all trailing spaces from cells then click kutools text remove spaces.

Remove trailing spaces in excel. 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. The goal is to replace the non breaking spaces with normal spaces. In the example show the formula in cell c3 is.

Trim substitute c9 char 160 now all of your leading and trailing spaces are cleaned up. How to clean leading and trailing spaces. To remove leading and trailing spaces from text string in cells you can use the trim function to remove extra spaces.

In the remove spaces dialog box check the trailing spaces option in spaces type section and then click the ok button. Now that we do not have the non breaking spaces anymore let us use the trim formula. If you need to strip leading and trailing spaces from text in one or more cells you can use the trim function.

Select a cell next to the cell you want to remove extra spaces from string type this formula. Substitute c9 char 160 step 2.