How To Delete Spaces In Excel

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.

How to delete spaces in excel. 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 the trim spaces button on the ribbon. Type trim b2 and press enter.

This removes the spaces anywhere from the selected cells. There are multiple ways to remove spaces in excel. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces.

Use the substitute function to remove all spaces or non breaking spaces. In the find what box enter a space. There we need to put a space and replace that with blank nothing kept.

Click on the top empty cell in your new column b2. Leave the replace with box as blank. E2 f2 g2 etc.

Choose one or more options. Now select replace all. Remove leading and trailing spaces trim.

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. 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.