alphabetize names

[brendar]

I need to alphabetize names in a column automatically? Is that possible?

 

[Nick Hodge]

Brendar

Could you give an example?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[Don Guillett]

Perhaps have a look in help index for SORT. Or, more info.

 

[Bill Ridgeway]

IF you have names in the format <forename family name> AND you need to sort
by family name you'll need a helper column for the family name element. To
do this-
insert a column immediately to the right of the name column
highlight the name column
Click on <Data><Text to columns><Next><Space><Next><Finish>

Regards.

Bill Ridgeway
Computer Solutions