How to Remove Extra Spaces in Excel

 

If you’ve ever copied and pasted some text into Microsoft Excel from an external source, you might have seen the spacing go awry. Nobody wants extra spaces and line breaks scattered in between text. Luckily, Excel has a simple function to fix this problem.

To remove extra spaces:

  1. Use the trim function. For example, let’s say cell A1 contains extra spacing.
  2. In a new cell, type in =trim(A1).

To remove extra spaces and line breaks:

  1. Use the trim and clean functions. For example, let’s say cell A2 contains extra spacing and line breaks.
  2. In a new cell, type in =trim(clean(A2)).

Click here to watch this video on YouTube.

Get the best tips and tricks in your inbox daily