Excel sorting [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I'm an Excel novice and I need to sort a list of email addresses on the company name or everything that appears after the @ sign. How do I do this?

Thanks so much


1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
for example email addresses are ther in A1 down
in B1 type this formula
=RIGHT(A1,LEN(A1)-SEARCH("@",A1))
copy B1 down
highlight both A and B column and sort according to column B (in this case "no header row")

if you want after sorting you can delete column B

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!