Remove Spaces In Excel After Text

The figure illustrates how you can remove superfluous spaces by using the trim function.

Remove spaces in excel after text. Select a cell next to the cell you want to remove extra spaces from string type this formula. In the find what field type two spaces. Now in the cell h4 let s apply a trim function.

Click replace and then the spaces in the cell have been removed. 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 trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces.

Easily split cells to multiple cells rows a column list in excel. The text we want is from cell a1 so in text select a1. If you also need to remove line breaks from cells you can add the clean function like so.

In the formulas tab click the text drop down menu in the functions section and select trim. Remove all characters after the first space select a blank cell enter the formula left a2 find a2 1 a2 is the cell where you will remove all characters after the first space into it and the drag the fill handle down to the range as you need. If the text in your column has extra spaces within the text not right before or right after you can quickly clean that text by using excel s search and replace feature.

Press the ctrl h shortcut to open excel s search and replace window. As shown in the following screenshot the excel trim formula successfully eliminated all spaces before and after the text as well as consecutive spaces in the middle of a string. We want to remove extra spaces so in old text box type which means space.

In cell b1 type substitute and go to formulas tab click on insert function option in excel to open the function dialog box. Simply give it some text and it removes all spaces from the text except for single spaces between words. The trim function in excel removes leading spaces extra spaces and trailing spaces.