removing extra spaces in cells (solved)

[NCay]

How can I remove extra spaces from within cells held in one column. There have been numerous typo's that have resulted in first, middle and last names being split by greater than one space in many though not all instances.
Thanks in advance

_________________

This message was edited by NCay on 2002-10-17 01:11

 

[Sbirro Cornuto]

Are the first, middle and last names all in the same Cell or each one in different Cells?

 

[NCay]

in one cell

 

[BigC]

Try this
=TRIM(text)

Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

Text is the text (or address of cell containing text) from which you want spaces removed.

Example

TRIM(" First Quarter Earnings ") equals "First Quarter Earnings"

HTH
BigC

 

[NCay]

ADVERTISEMENT

when I follow this through I end up with a #NAME? error, any idea on what's causing this? Otherwise the trim function should work- now that I know it exists!!!

 

[Juan Pablo González]

Well, you should be able to use that formula, if you're typing it correctly... so, can you find it throught the Paste Formula Wizard ?

 

[NCay]

just to show my inadequacies...
I tried to do it without ()

D'OH!

Cheers again guys, it's working now