Excel Formula To Remove Spaces

This removes the spaces anywhere from the selected cells.

Excel formula to remove spaces. The easiest way to get rid of excess spaces is using the standard excel find replace option. Press space bar in the find what field and make sure the replace with field is empty. If your data set contains superfluous spaces the excel trim function can help you delete them all in one go leading trailing and multiple in between spaces except for a single space character between words.

For example if you want to remove all of the spaces from the c column click the first box e g. In the example show the formula in cell c3 is. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces.

The trim function in excel removes leading spaces extra spaces and trailing spaces. Remove spaces in excel. The trim function does not remove single spaces between words.

Create a new empty column beside the column you want to remove spaces from in this example this new column starts with b2. The trim function is relatively straightforward. Open the worksheet contains the cells you will remove leading spaces from and then press the alt f11 keys to open the microsoft visual basic for.

Remove only trailing spaces from cells. C2 in the column that isn t the title. Click insert module then copy below vba code into the module window.

There we need to put a space and replace that with blank nothing kept. Type trim b2 and press enter. Press ctrl space to select all cells in a column.