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.
FAQs
What is the easiest way to remove extra spaces in Excel?
The easiest way is to use the Find and Replace feature by searching for double spaces and replacing them with single spaces. Repeat this until all extra spaces are removed, or use the TRIM function to automatically clean leading, trailing, and extra spaces within text.
How does the TRIM function work in Excel?
TRIM removes all extra spaces from text except for single spaces between words. It eliminates leading, trailing, and multiple spaces, making data cleaner without affecting the content or formatting of your cells.
Can I remove extra spaces from multiple cells at once?
Yes, you can select multiple cells and use Find and Replace to remove extra spaces simultaneously. Alternatively, apply the TRIM function across a range with a helper column and copy-paste the cleaned data as values.
What shortcut opens the Find and Replace dialog in Excel?
The shortcut is Ctrl + H on Windows and Cmd + H on Mac. This opens the Find and Replace window where you can specify text to search for and replace, such as double spaces to single spaces.
Why does Find and Replace need to be used multiple times to remove all extra spaces?
Because Find and Replace typically replaces fixed patterns like two spaces with one space, repeating the process ensures all occurrences, even multiple consecutive spaces beyond two, are cleaned up throughout the data.
Is there a way to automatically trim spaces when importing data into Excel?
Excel’s Power Query or Text Import Wizard offers options to clean data during import. You can automatically trim spaces or convert data to prevent extra spaces from being inserted when importing from external files.
Will the Find and Replace method affect spaces at the beginning or end of the text?
No, Find and Replace targets spaces exactly as entered (like double spaces between words) but doesn’t trim leading or trailing spaces. Use the TRIM function to remove leading and trailing spaces instead.
How can I remove extra spaces in formulas or calculated cells?
Use the TRIM function inside your formulas to clean text output. For example, =TRIM(A1) removes extra spaces from the value in A1 before performing further calculations or displaying results.
Can extra spaces cause errors in Excel formulas?
Yes, extra spaces can affect lookup functions like VLOOKUP or MATCH by preventing exact matches, leading to errors or unexpected results. Removing spaces ensures formulas work as intended.
Does replacing double spaces with single spaces affect spacing between words?
Replacing double spaces with single spaces standardizes spacing between words, improving readability and preventing formatting issues without affecting the meaning of the text.