How to Remove Extra Spaces in Excel

1. Start by opening the Excel workbook that contains the data with extra spaces.

2. Click and Drag to select the cells with extra spaces.

3. Then press "Ctrl/Cmd + H" on the keyboard.

4. Click on "Find what" and enter two spaces using the space bar on your keyboard.

5. Following that, click on "Replace with" and enter one space.

6. Now, click on "Find all".

7. Finally, click on "Replace all".

8. That's it, Excel trimmed all the texts with double spaces with one space now.

9. Enjoyed the guided demo?

This interactive demo/guided walkthrough on How to Remove Extra Spaces in Excel was created using Supademo.

How to Remove Extra Spaces in Excel : Step-by-Step Guide

Begin by launching Excel and opening the workbook that contains your data. This is where you’ll be cleaning up any unwanted extra spaces to ensure your information is neat and consistent.

Next, locate the specific cells that have the extra spaces. Click and hold your mouse button, then drag to highlight all the affected cells you want to fix. This selection tells Excel exactly where to focus the cleanup.

With your cells selected, press the keyboard shortcut "Ctrl + H" on Windows or "Cmd + H" on Mac. This opens the Find and Replace dialog box, which will help you quickly remove those extra spaces.

In the dialog box, click inside the "Find what" field and type two space characters using the space bar. This tells Excel exactly what to look for within your selected cells.

Move to the "Replace with" field next and enter a single space. This instructs Excel to replace those double spaces with just one, helping tidy up your text.

Before you finalize, click on the "Find All" button. This allows you to preview all instances where double spaces exist, confirming Excel is targeting the right spots.

When you’re ready, click "Replace All" to have Excel automatically fix every double space in your selection with a single space, streamlining your data at once.

That’s it! Excel has now cleaned up all the text by converting those double spaces into single spaces, making your data much easier to read and work with.

We hope you found this step-by-step guide helpful. Ready to tackle more data cleanup tasks? Let’s keep going!

Create your own interactive demos in < 5 mins with Supademo

You can create your own interactive product demo in minutes using Supademo. Drive growth, scale enablement, and supercharge product-led onboarding with Supademo. Sign up for free here with no credit card required.