How To Remove Space In Excel Before Numbers

So value in cell a2 is 1 trim function does not work for removing the space before the 1.

How to remove space in excel before numbers. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. Press f5 key to run the code then a. There we need to put a space and replace that with blank nothing kept. 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.

Select the cells containing spaces you will remove press the ctrl h keys to open the find and replace dialog box. Press alt f11 key to enable microsoft visual basic for applications window. Press space bar in the find what field and make sure the replace with field is empty. There are multiple ways to remove spaces in excel.

It will remove all the leading spaces in the excel cell and we have numbers in order now. Remove spaces in excel. For example if you want to remove spaces from c2 through c30 highlight those cells. Click insert module to create a new module script copy and paste below code to the script.

Trying to remove the space in front of the number 1 in cell a2. In the find and replace dialog and under the replace tab type one space into the find what textbox keep the replace with textbox empty and then click the replace all button. Trim a2 where a2 is the cell you want to delete spaces from. Press ctrl h and a dialog box appears for find and replace.

Below in find what box press spacebar and in replace button to leave it a blank and click on replace all. This removes the spaces anywhere from the selected cells. Press ctrl h to open the find replace dialog box. Highlight the range in which you want to remove all spaces.

A dialog box will appear. A regular trim formula is as simple as this. Now don t enter anything in replace what. Click the edit menu.

The easiest way to get rid of excess spaces is using the standard excel find replace option. Press ctrl space to select all cells in a column. We will consider the same data used in example 1. Press ctrl h and type single space in find what.

Select the data first. Remove leading spaces from strings with the vba code 5 steps 1.