How To Remove Space In Excel Cell

Easily remove leading trailing extra and all spaces from cells with the kutools 1.

How to remove space in excel cell. Now in the cell h4 let s apply a trim function. Now press ctrl h. The text from a4 with extra spaces will appear in a6 but with all of the extra spaces removed.

Click the trim spaces button on the ribbon. For example to remove a non breaking space you can use. Select the cell or range of cells from which you want to remove white spaces.

Use the shortcut key. The excel trim function removes all spaces from text except a single space between words. Select a range or multiple ranges with the cells you will remove spaces from click kutools text remove spaces.

And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps. Choose one or more options. You will see below find replace window.

By adding the substitute function to the formula you can remove specific characters. In find what input bar insert a blank space using the space bar and replace with should remain blank. 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.

Now in the replace with. Click the top cell in a blank column. Remove leading and trailing spaces trim.