How To Delete Spaces In Excel

The trim function in excel removes leading spaces extra spaces and trailing spaces.

How to delete spaces in excel. Select the cells range entire column or row where you want to delete extra spaces. There we need to put a space and replace that with blank nothing kept. Hold down the shift key and hover your mouse. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h.

Choose one or more options. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. Step 1 open find and replace dialogue box by pressing control h. And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps.

Leave the replace with box as blank. Now select replace all. E2 f2 g2 etc. Easily remove leading trailing extra and all spaces from cells with the kutools 1.

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. There are multiple ways to remove spaces in excel. Use the substitute function to remove all spaces or non breaking spaces. Remove leading and trailing spaces trim.

Select a range or multiple ranges with the cells you will remove spaces from click kutools text remove spaces. By another way we can remove the spaces by using a trim function. Click on the top empty cell in your new column b2. Click the top cell in a blank column.

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. This removes the spaces anywhere from the selected cells. You can see there are 5 options in the remove spaces dialog box.

Remove spaces in excel. Type trim b2 and press enter.