How to get last name from A Column to copy to B column

Abraham Lincoln Lincoln
Alexander Hamilton Hamilton
George Washington Washington

I have a list of first and last name in column A. But I need to sort them alphabetically by last name. My best idea was to copy the last name into another column and sort alphabetically by that column. How can I automate this using a Macro or VBA? I'm a student at UCF with medium knowledge of Excel.

Hello rd12345,

Here is a macro that will separate the last names and place them in column "B". The names are then sorted in A to Z order. Run the macro by using ALT+F8 to display the Macro Dialog List and select SortByLastName

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S

Sincerely,
Leith Ross

Yes, Elvis is alive! Your idea worked. You are a lifesaver. You have saved me so much time. Thanks a million

without going down the vba macro route for names in the format
xxxxx yyyyyy in column a, try in b1 =MID(A1,(FIND(" ",A1)+1),50)
if the surname is longer than 50 letters i'll eat my hat!