Delete Spaces In Excel

And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps.

Delete spaces in excel. Select a range or multiple ranges with the cells you will remove spaces from click kutools text remove spaces. There we need to put a space and replace that with blank nothing kept. Easiest way to replace spaces in a selection or within a sheet is by the find and replace dialogue box.

Choose one or more options. How to delete all spaces in a selection or how to delete spaces in a sheet. A dialog box will appear.

The trim function in excel removes leading spaces extra spaces and trailing spaces. For example if you want to remove spaces from c2 through. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces.

This removes the spaces anywhere from the selected cells. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. Hold down the shift key and hover your mouse.

You can see there are 5 options in the remove spaces dialog box. There are multiple ways to remove spaces in excel. By adding the substitute function to the formula you can remove specific characters.

Type trim b2 and press enter. Highlight the range in which you want to remove all spaces. Click the box beneath find what.