last name alphabetical order

[Reds0602]

How do I get a list of First and Last names in a column to automatically be
put in alphabetical order by last name?
Can you help please? A direct answer to (e-mail address removed) would be greatly
appreciated. Thanks again

 

[Fred Smith]

You need to parse out the last name. Create a helper column of just last
name using something like:
=right(a1,len(a1)-find(" ",a1))

Regards,
Fred

 

[JB]

See example.

http://boisgontierjacques.free.fr/fichiers/Tri/TriPrenomNom.xls

JB
http://boisgontierjacques.free.fr/

 

[David Biddulph]

Data/ Text to Columns will split your first and last names.

 

[Don Guillett]

Rob Bovey created a parsenames file years ago that still seems to work. Ask
him if he still has it for free?

http://www.appspro.com/