How To Remove Space In Excel Cell

Click the top cell in a blank column.

How to remove space in excel cell. E2 f2 g2 etc. Now press ctrl h. The text from a4 with extra spaces will appear in a6 but with all of the extra spaces removed. Select the cells range entire column or row where you want to delete extra spaces.

Now in the replace with. Easily remove leading trailing extra and all spaces from cells with the kutools 1. For example to remove a non breaking space you can use. By adding the substitute function to the formula you can remove specific characters.

To remove extra spaces with the trim function follow this procedure. Choose one or more options. The cell must be on the same row as the first line of data in the column with the spaces. How to remove leading spaces in excel cell.

Box type two space character. Select a range or multiple ranges with the cells you will remove spaces from click kutools text remove spaces. You can see there are 5 options in the remove spaces dialog box. In the formulas tab click the text drop down menu in the functions section and select trim.

Use the shortcut key. 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 find what input bar insert a blank space using the space bar and replace with should remain blank. Type only one space.

Select the required area s double space to be removed. And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps. Click the trim spaces button on the ribbon. 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.

Click on cell a6 to make it the active cell this is where the function will go. Control h to activate find and replace option. The excel trim function removes all spaces from text except a single space between words. 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.

Remove leading and trailing spaces trim. In the find what.