That may well work for you. STEPS: Firstly, create a Helper Column & type the formula. If you pick Trim leading/trailing spaces, the spaces before and after cell values will be deleted. Click Ctrl+ Space then highlight all the cells in the column, 2. You can also click the Home tab in the Ribbon and select Replace in the Find & Select group. Highlight the rows where you want to delete leading spaces, 5. Step 3: Excel displays a message stating the number of replacements. Open the Find and Replace dialog box by clicking Ctrl+ H, 3. Step 4. Starting at approximately 5 PM CST (11 PM UTC) on November 7, 2022, we will perform maintenance on the Spiceworks Cloud Help Desk (CHD). Read More: How to Remove Space between Rows in Excel (5 Methods). The above command will open a new pop-up window named ' Find and Replace '. To know more about the SUBSTITUTE function read the article How to use SUBSTITUTE function in Excel (4 Examples). 2013-2022 ExcelDemy.com. We can see that product codes contain extra spaces after numbers. The leading and trailing spaces can be in between the words and spaces thus making your work look disorganized and disorderly. Sometimes, it is a mistake. Excel for Finance Step 1: Select the data first. We can see that the Find & Replace options modify the source data. In the Find what box, type a space. If yes, concatenate the new string (space removed). Select the column from which you need to remove the spaces. Follow the steps below to see how to use this function. /* ]]> */, How to Remove Space in Excel before Numbers (3 Ways), 3 Ways to Remove Space in Excel before Numbers, 1. 0. dropdown.parentNode.submit(); } Select the helper column and delete it. The SUBSTITUTE function in Excel substitutes a text in a given string with another specific text. if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { Method 1: How to remove all spaces between numbers, Method 2: How to remove leading or trailing spaces, Method 3: How to remove all the spaces in Excel using the =SUBTITUTE() function. Click the space bar on the Find what section and leave the Replace with section as it is. Click CTRL + H (to bring up the find replace tool) In the Find What box type (*)- this tells Excel if must look for a ' (', then other characters (as many as there are), and then a ')'.