Sometimes, when you import data into a worksheet, 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.