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

"Reds0602" wrote in message
...
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 would be greatly
appreciated. Thanks again