1. Computing
When data is imported or copied into a spreadsheet extra spaces can sometimes be included with the new data. When this happens, it can prevent the data from being used in spreadsheet formulas.

The TRIM function, one of Excel's text functions, can be used to remove these additional spaces.

This function allows you to specify the location of the text to be modified and then removes all unnecessary spaces.

To find out the details of using this function read the article on the Excel 2007 TRIM Function.

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.