Breaking apart email addresses and sorting

**captainb360** · 06-16-2010, 09:36 AM

I am probably like 99% of those who use Excel - I don't know how to use it, so bare with me.

I have a CSV list with email addresses. I would like to be able to sort my list by url portion of the email. i.e. johnsmith@smithco.com - I want to be able to sort by the 's' in smithco, not the 'j' in johnsmith. Possible?

Thanks very much!

**martindwilson** · 06-16-2010, 09:43 AM

in another column just put =MID(A1,FIND("@",A1)+1,255) fill down then sort by that column

**captainb360** · 06-17-2010, 09:32 AM

Thanks for the response! I must not be doing it correctly...I took what you wrote, copied and pasted it into a column, did the fill down, but all its doing is showing the formula in each column nothing happened...the email addresses are in the B column and start in row 2, so I adjusted your "A1" to be "B2", but I didn't assume that would mess anything up? Thanks for the help.

**shg** · 06-17-2010, 09:34 AM

Format the column with the formula as Number, and try again.

**captainb360** · 06-18-2010, 09:42 AM

Embarrassing...but I am not sure how to do what you are suggesting with formatting the column. Is there anyway to spell this out some so that I may be able to figure it out? Thanks for the patience.

**martindwilson** · 06-19-2010, 05:28 PM

if you put =a1 in a spare column and drag down does the same thing happen i.e does it still show just the formulas? its possible the cells were formatted text before you entered formulas
quick fix is to select column with formulas in
then
select the data tab
click text to columns
the convert text to columns window will open
just click finish