How to Remove a Space before Numbers in Excel (3 Easy Ways)

Last updated: May 3, 2024

The sample dataset contains 5 Product Names and Product Codes,where the product codes contain extra spaces before the numbers.

Method 1 – Using the TRIM Function to Remove Space Before Numbers in Excel

=TRIM(C5)

Read More: How to Remove Tab Space from Excel

=SUBSTITUTE(C5," ","")

NOTE: Here, I have copied the Product Codes into the Correct Code column for better representation.

Press Ctrl + H on your keyboard to open the Find and Replace option.
In the Find What option, enter a Space.
In the Replace With box, make sure there is no space or extraneous characters.
Click on Replace All.

You have to create an extra column in order to get results for methods 1 and 2.
You can not only remove the spaces before numbers but also remove spaces between and after numbers using these methods.
You need to copy the data into another column if you want to see the changes side-by-side for method 3.
You can apply the Find and Replace option to remove spaces for multiple rows and columns at a time. To do so, do not select any particular column and follow the rest of the steps.

Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.