last name alphabetical order

R

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sheets in alphabetical order 2
How do I separate first and last names into two columns? 2
Open File menu sort alphabetical. 6
alphabetical order in a colume 1
putting a column of names into alphabetical order 1
How to sort names in alphabetical ascending order? 7
how i get defferent names in alphabetical order 2
Alphabetical Order (check for duplicates) 7

Top