Remove Spaces In Excel

Click the trim spaces button on the ribbon.

Remove spaces in excel. To get the length of a string use the len function. Click the top cell in a blank column. And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps.

E2 f2 g2 etc. Choose one or more options. Select the cells range entire column or row where you want to delete extra spaces.

Note that clean is not able to remove all non printing characters notably a non breaking space which can be appear in excel as char 160. Easily remove leading trailing extra and all spaces from cells with the kutools 1. The cell must be on the same row as the first line of data in the column with the spaces.

The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. You can use the substitute function to. 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.

Press ctrl space to select all cells in a column. The trim function does. Press space bar in the find what field and make sure the replace with field is empty.

Press ctrl h to open the find replace dialog box. Control h to activate find and replace option. In find what input bar insert a blank space using the space bar and replace with should remain blank.