Remove Spaces In Excel Cell

There we need to put a space and replace that with blank nothing kept.

Remove spaces in excel cell. Trim clean text the clean function removes a range of non printing characters including line breaks and returns cleaned text. Click on the top empty cell in your new column b2. Select a cell next to the cell you want to remove extra spaces from string type this formula trim b2 b2 is the cell you want to remove spaces from see screenshot.

In order to deal with these unwanted spaces problems we have a built in function called trim in excel which can remove all the unwanted spaces in excel cell. And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps. The trim function then takes over to remove extra spaces and returns the final text.

Using clean trim. There is also another possibility that you ll get a line. Choose one or more options.

Select the cells range entire column or row where you want to delete extra spaces. There are multiple ways to remove spaces in excel. Press ctrl h to open the find replace dialog box.

Press ctrl space to select all cells in a column. The trim function removes all the spaces except the single space after each word. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h.

Select the cells containing spaces you will remove press the ctrl h keys to open the find and replace dialog box. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. This removes the spaces anywhere from the selected cells.