Sorting table by last name

[teeprodnuk]

Hello everyone!
I have what seems a simple request but I cannot seem to find an easy answer.
I am trying to sort a list of names I have in my table by last name A-Z. But the names are formatted like this: "James Aaron", "Tyler Burke", and so on.
The way I understand sorting, I can sort by first name A-Z and Z-A, but not by last name. Is there an easier way to fix this?
Thank you all in advance for your help (and patience)!

 

[Somendra Misra]

Hi,

Can you post a sample file.

Regards,

 

[teeprodnuk]

Hi,

Can you post a sample file.

Regards,

Of course. My apologies.

 

[Somendra Misra]

Are the names in your file has the structure of
last name first name

Regards,

 

[Sathish KV]

Hi,

I don't think you have an option to do this

You need to bring in the correct name format in the last column with a formula like =MID(A2,FIND(" ",A2)+1,LEN(A2)) and then sort it

 

[teeprodnuk]

Are the names in your file has the structure of
last name first name

Regards,

No, that's where I'm having the struggle. I'm accessing the data in this format (first name, last name). I was hoping there'd be a way to sort it without having to upset the data too heavily.

 

[bobhc]

As per the upload?

 

[teeprodnuk]

I got two very good workarounds for this from several of you. Thank you so much! I'm learning more about Excel every day!

Grace and peace to you all!

Tee Jay

 

[Somendra Misra]

I don't think Excel inbuit feature allows that.

Regards,

 

[bobhc]

@Somendra Misra

Text to columns.

 

[Somendra Misra]

@bobhc

Hi... My comment was not regarding your solution, it was regarding the original post of sorting w.r.t second word in name.

Regards,

 

[bobhc]

OK, understand