Eliminate Spaces In Excel

The cell must be on the same row as the first line of data in the column with the spaces.

Eliminate spaces in excel. Remove leading and trailing spaces. Choose one or more options. The trim function in excel removes leading spaces extra spaces and trailing spaces.

Select the cells range entire column or row where you want to delete extra spaces. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. Click on the top empty cell in your new column b2.

There we need to put a space and replace that with blank nothing kept. For example if you want to remove spaces from column c and c s first row of data is in row 2 c2 click the second cell in your blank column e g. Use the substitute function to remove all spaces or non breaking spaces.

Select a range or multiple ranges with the cells you will remove spaces from click kutools text remove spaces. Removing extra spaces from an entire column create a new empty column beside the column you want to remove spaces from in this example this new column starts with. Press ctrl h to open the find replace dialog box.

Trim clean text the clean function removes a range of non printing characters including line breaks and returns cleaned text. 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. If you also need to remove line breaks from cells you can add the clean function like so.

Select a cell next to the cell you want to remove extra spaces from string type this formula trim b2. The trim function then takes over to remove extra spaces and returns the final text. E2 f2 g2 etc.