How To Remove Trailing Spaces In Excel

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.

How to remove trailing spaces in excel. Compare with the trim function in excel the removing spaces utility in kutools for excel provides more flexible way to remove all the excessive space in excel. Remove leading and trailing spaces with excel formula. Remove all extra spaces from strings with the trim function 2 steps. You can directly remove the space in the cell without moving them into other cells.

Select the range you want to remove all trailing spaces from cells then click kutools text remove spaces. Substitute c9 char 160. We will use the substitute formula to remove the non breaking spaces depicted by char 160 the goal is to replace the non breaking spaces with normal spaces. So you can type the following formula in cell b1 then press enter key.

To remove leading and trailing spaces from text string in cells you can use the trim function to remove extra spaces. 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. Press enter key to get the result then. Download excel workbook step 1.

How to remove leading and trailing spaces in excel cells. In the example show the formula in cell c3 is. If you want to convert or import all data.