• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Remove Spaces in Excel

March 18, 2021 by Andrew Childress
Clean remove spaces Excel

If you work in Excel and deal with imperfect data? That means that you'll need to clean up and remove spaces in Excel workbooks.

If you work in Excel, I’ll bet that you deal with imperfect data. That means that you’ll need to clean up data and take actions like remove spaces in Excel workbooks. Let’s learn how.

Remove Spaces in Excel

Let’s say that you get a workbook with some ugly sentences. No offenses intended to imperfect sentences – it’s just that some have too many spaces!

The example below is all too common. A lot of data comes out of systems that don’t handle sentences and paragraphs properly, adding too much space and cruft in between.

How to remove spaces Excel

To correct the issue, use the =TRIM(). function. In our example, we’re going to use =TRIM(B3) to trim the text inside the cell B3.

Check out the results below – Excel automatically cleans up the text and removes the double spaces inside the cell.

Remove spaces in Excel

Don’t spend time rewriting and retyping your spaced sentences. Instead, just use the TRIM function and point it to a cell with overly spaced text.

Removing Line Break Spaces in Excel

You’ve already learned how to remove extra spaces between words. But many times, your data will have extra spaces either before or after the content in the form of line breaks. If you’re working with longer blocks of text, this is a must to clean up.

In this case, we’re going to use the =CLEAN() function. Applying this to a cell with line breaks will consolidate the text to a single line. In the example below, I use =CLEAN(B3) to remove the line break in the text from cell B3.

Clean remove spaces Excel

After you apply the text, Excel puts everything on a single line in the resulting cell.

Result remove spaces Excel

Always remember: you can Copy your trimmed text and Paste as Values to paste out the cleaned-up text. That way, you don’t have to keep the original, overly spaced text.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Excel goal seek exampleGoal Seek in Excel
Next Post:Error Bars in ExcelError bars Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top