Summary: Trim extraneous text inside and surrounding text values.
When copying and pasting text from another application into a Microsoft Excel 2003 spreadsheet, or in other circumstances where entered data may not meet desired specifications, text may contain extra spaces inside and surrounding the words.
For example, if you have a spreadsheet containing a list of names and plan on displaying those names via functions in other cells, it may prove useful to remove extra spaces else the function results may appear awkward.
=trim(VALUE)
VALUE is the value you wish to trim.
For example, assume the following spreadsheet:
A
1 Bill Connor
2 Sarah Jones
3 John Williamson
4 Laura Smith
5
6 =TRIM(A1)
7 =TRIM(A2)
8 =TRIM(A3)
9 =TRIM(A4)
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: August 22, 2008, at 8:52 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: