How To Remove Spaces In Excel

To remove spaces in Excel, use the TRIM function by entering ‘=TRIM(cell reference)’ in a new column or directly over the existing column, to delete trailing, leading, and excessive spaces, and the output is ‘Expectation’.

Excel is a powerful tool for organizing and analyzing data, but sometimes the data we work with contains unnecessary spaces that can be a headache to deal with. Whether you are trying to sort a list, perform calculations, or create a clean and professional-looking spreadsheet, removing extra spaces is essential. In this blog post, we will explore various methods and techniques to effectively remove spaces in Excel, helping you streamline your data and enhance your productivity. From simple formulas to advanced functions, we have got you covered! So, let’s dive in and learn how to eliminate those pesky spaces quickly and easily.

How To Remove Spaces In Excel: Step-by-Step


Step 1: Open Excel Document,

To begin the process, locate and open the Excel document containing the data that requires the removal of any unnecessary spaces or gaps.

Next Step

Step 2: Select Blank Cells,

Consecutively click the top of a column to select the entire column or manually select the cells where you want to remove spaces easily and efficiently.

Next Step

Step 3: Navigate to ‘Find & Select’,

To access the ‘Find & Select’ button, navigate to the home tab located in the toolbar at the top of your screen and give it a click.

Next Step

Step 4: Select ‘Replace’,

From the ‘Find & Select’ drop-down menu, choose ‘Replace’. This will open the ‘Find and Replace’ dialog box where you can search for specific text and replace it with new content in your document.

Next Step

Step 5: In the ‘Find what’ Box,

In the ‘Find what’ box, pressing the space bar once allows you to specify a blank space for Excel to search and replace. This helps you identify and modify specific instances of blank spaces within your spreadsheet.

Next Step

Step 6: Leave ‘Replace with’ Box Empty,

By leaving the ‘Replace with’ box empty in Excel, you instruct the software to eliminate all spaces in the selected cells or range, effectively deleting them from the data.

Next Step

Step 7: Click ‘Replace All’,

After clicking the ‘Replace All’ button in Excel, the software will automatically replace the desired content throughout the selected cells, saving time and effort in manually replacing each instance individually.

Next Step

Step 8: Close ‘Find and Replace’ Dialog Box,

Once all spaces have been deleted, simply close the ‘Find and Replace’ dialog box to complete the process.

Next Step

Step 9: Review Results,

After applying the necessary changes, carefully examine the selected cells to ensure that all spaces have been successfully eliminated as required. Verify the accuracy of the updated data.


In conclusion, removing spaces in Excel can greatly enhance the efficiency and accuracy of your data analysis and manipulation tasks. By using the various techniques outlined in this blog post, you can eliminate unwanted spaces and ensure your information is properly formatted. Whether you leveraged Excel’s built-in functions, such as TRIM and SUBSTITUTE, or employed more advanced methods like using formulas or Excel VBA macros, you now have the tools to effortlessly handle spaces in your spreadsheets.

Remember, consistency in data formatting is crucial for seamless data processing and generating reliable insights. By regularly reviewing and removing spaces, you can streamline your workflows and maintain high data integrity. So, the next time you encounter spaces causing discrepancies or hindering your data operations, refer back to this blog post and take the necessary steps to eliminate them. Your Excel skills will undoubtedly flourish, leading to more accurate analysis and better decision-making in your professional endeavors.

Embrace the power of space-free Excel sheets and unlock the full potential of your data!

Table of Contents