Three ways to remove spaces in numbers in Excel

In the process of typing by chance, you can put two spaces instead of one or set it in the wrong place. Unfortunately, it’s hard to notice when working to fix it right away. But fortunately, in the end, you can take advantage of some tricks that will allow you to quickly fix the current situation. The article will tell you how to remove spaces between numbers in Excel, but it’s worth mentioning right away that this also works with text.

Method 1: Replace Tool

If during work you accidentally put a double space in many cells, then using the Replace tool you can remove unnecessary voids in an instant. Here's what you need to do to do this:

1. Open the desired table in the program.
2. Go to the "Home" tab.
3. On the toolbar, find and left-click on the item "Find and Select".
4. In the menu that appears, select the "Replace" option.
5. In the window that appears, enter two spaces in the “Find” column, simply double-clicking on the corresponding key on the keyboard.
6. In the column “Replace with”, enter one space.
7. Click the Replace All button.

After that, a report will appear, exactly how many double spaces have been fixed. Click "OK" to accept it. After that, you can observe that all double spaces have been corrected and your document is brought back to normal. This is the first way to remove spaces in numbers in Excel, move on to the next.

Method 2: remove spaces between delimiters

If you set not a double, but a single space in numeric expressions, then the previous method will not help you. But you can make some adjustments to it that will help correct the current situation. To remove spaces in numbers in Excel, follow these steps:

1. Select the part of the table with numerical data that contains extra spaces.
2. On the toolbar, again click on the "Find and Select" button and select the "Replace" option. By the way, this action can be performed by using the keyboard shortcut Ctrl + H.
3. A familiar window will appear where you need to enter two variables.
4. In the "Find" field, enter a single space.
5. Do not touch the “Replace with” field, it should not contain anything.
6. Click the Replace All button.

Like last time, you will be shown a report that you can close by clicking the "OK" button. All spaces between numbers will be removed. This is a great way to remove spaces in numbers in Excel, but it is only effective when these spaces were set manually. If they are installed automatically, then you must use a completely different instruction. It is about her that we will discuss further.

Method 3: delete by formatting

If you type large numbers in the table cells and see that after pressing Enter a space appears between the delimiters, then you have the appropriate formatting option. Now we will tell you how to remove spaces in numbers in Excel by disabling it.

1. Open the table in the program.
2. Select the cells in which there is a space between the numbers.
3. Right click on the selection.
4. Select the option “Cell format” in the pop-up menu that appears.
5. In the window that appears, go to the "Number" tab.
6. Open the Numeric section in the sidebar.
7. In the right part of the window, uncheck the line “Separator of discharge groups”.
8. Click OK.

After that, the window will be closed, and you can observe that all extra spaces have been removed from the document. As you can see, this is a fairly simple way to remove spaces in numbers in Excel, but keep in mind that it works only in cases of text formatting.