Last post discussed Excel's TRIM function that, normally, will remove extra spaces from imported text and leave just one space between words.
Occasionally, however, TRIM can't do the job.
On a computer, a space between words is not just empty air but a character, and there are actually several different space characters.
The TRIM function was designed to work on the everyday character entered using the space bar, but it can't handle what's known as a non-breaking space that is frequently used in web pages.
To find out the details, read this short tutorial on what to do When the TRIM Function Doesn't Work.