How To Remove Extra Spaces In Excel

The text we want is from cell a1 so in text select a1.

How to remove extra spaces in excel. There are multiple ways to remove spaces in excel. There we need to put a space and replace that with blank nothing kept. For removing all these extra spaces from cells the trim function can help.

Remove all extra spaces from strings with the trim function 2 steps remove extra spaces from strings. We want to remove extra spaces so in old text box type which means space. There is also another possibility that you ll get a line.

The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. Press enter key to get the result then drag auto fill handle over the cells you want to remove extra spaces. Remove extra spaces using trim function trailing and leading.

The text from a4 with extra spaces will appear in a6 but with all of the extra spaces removed. In the new text type which means no spaces then click on ok. This method is quite easy if you only need to remove.

It happens sometimes that you get trailing and. In cell b1 type substitute and go to formulas tab click on insert function option in excel to open the function dialog box. Click on cell a6 to make it the active cell this is where the function will go.

Using clean trim. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. The trim function in excel removes leading spaces extra spaces and trailing spaces.