How to sort by email address

[millergg]

Hi,
I have a spreadsheet with the following headers: First Name, Last Name, Email, Login Access? and Status.
It has 3,897 rows. Office 365. On Windows 10,

I would like to sort by email address - emails look like: username@differentBanks.com.
I don't need to sort by the first part (username) but by the last part (differentBanks.com)

Not sure how to do this. Any help is greatly appreciated!

Thanks,
George

 

[Joe4]

Welcome to the Board!

One easy way would be to use a helper column to pull out the part of the email address after the "@", like this:

=TEXTAFTER(C1,"@")

Then you can use that helper column to sort.

 

[millergg]

Thanks, Joe4!! I appreciate the speedy repy!
I'll give that a whirl, looks like it will work nicely!

 

[millergg]

@Joe4 - Worked perfectly! I knew there should be an easy way to do this.
Appreciate your help greatly - saved me a lot of time.

 

[Joe4]

You are welcome.
Glad I was able to help!