Remove Extra Spaces From Data in Excel

Remove Extra Spaces From Between Data
© Ted French

Sometimes, when you import data extra spaces show up between the words or numbers.

Extra spaces between words can make it difficult to read the information.

Extra spaces in numbers can cause errors when you try to use them with some of Excel's functions.

A quick and easy way to fix these problems is to use the TRIM function.

The TRIM function works by extracting the good data from the original and copying it to a new location in the worksheet.

To find out the details, read this short tutorial on how to Remove Extra Spaces From Data in Excel.

Related Tutorials

• Truncate Text Strings in Excel
• Extract a Substring Using the MID Function
• Concatenate Text Strings in Excel