1. Computing
Ted French

When the TRIM Function Doesn't Work

By January 1, 2014

Follow me on:

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 get rid of non-breaking spaces TRIM needs some help from the SUBSTITUTE and CHAR functions.

To find out the details, read this short tutorial on what to do When the TRIM Function Doesn't Work.

Related Tutorials

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.