How To Remove Trailing Spaces In Excel

Press enter key to get the result then.

How to 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 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 leading and trailing spaces in excel cells. Remove leading and trailing spaces with excel formula.

In the example show the formula in cell c3 is. To remove leading and trailing spaces from text string in cells you can use the trim function to remove extra spaces. If you want to convert or import all data.

Download excel workbook step 1. 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. 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.

You can directly remove the space in the cell without moving them into other cells. In the remove spaces dialog box check the trailing spaces option in spaces type section and then click the ok button. Remove all extra spaces from strings with the trim function 2 steps.