Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Trim Extra Spaces from Text

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)

In cells A1 - A4, the names contain extra spaces before, in the middle of, and afterwards.

Cells A6 - A9 would show the following cleaned-up values:

A6: Bill Connor
A7: Sarah Jones
A8: John Williamson
A9: Laura Smith

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.

Print this tip.

- Subscribe!

Search the Site: