last name alphabetical order
 

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

last name alphabetical order
 

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

last name alphabetical order
 

See example.

http://boisgontierjacques.free.fr/fi...iPrenomNom.xls

JB
http://boisgontierjacques.free.fr/

On 12 sep, 05:54, Reds0602 wrote:
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

last name alphabetical order
 

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

"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

last name alphabetical order
 

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/

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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