Sort a column (specifically email data) by end of text, not beginn

One of my files contains a field of Emails. I want to sort it by the ISP, not
the beginning of the text. so if an email is none@aol.com, I want to sort it
so I can view all the @aol.com,@hotmail.com, etc. -- the only way I know how
to sort is by Ascending/descending and it sorts by the beginning of the text.
Thanks!

Create a 'helper column' in which you tease out the ISP. Ex: if the email
address is in A2, enter =RIGHT(A2,LEN(A2)-FIND("@",A2)) in B2 to calculate
just the ISP. Autofill that formula to each row, then sort based on the new
column.

"Zip code help" wrote:

> One of my files contains a field of Emails. I want to sort it by the ISP, not
> the beginning of the text. so if an email is none@aol.com, I want to sort it
> so I can view all the @aol.com,@hotmail.com, etc. -- the only way I know how
> to sort is by Ascending/descending and it sorts by the beginning of the text.
> Thanks!

I can not get it to auto fill. I put the code in and wanted to drag and drop
for the remaning fields, but will not copy to the next number. Any ideas?
Thanks

"bpeltzer" wrote:

> Create a 'helper column' in which you tease out the ISP. Ex: if the email
> address is in A2, enter =RIGHT(A2,LEN(A2)-FIND("@",A2)) in B2 to calculate
> just the ISP. Autofill that formula to each row, then sort based on the new
> column.
>
> "Zip code help" wrote:
>
> > One of my files contains a field of Emails. I want to sort it by the ISP, not
> > the beginning of the text. so if an email is none@aol.com, I want to sort it
> > so I can view all the @aol.com,@hotmail.com, etc. -- the only way I know how
> > to sort is by Ascending/descending and it sorts by the beginning of the text.
> > Thanks!

Assuming that Column A contains your data, enter the following formula
in B1 and copy down:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

Then, select Column A and Column B, and sort by Column B.

Hope this helps!

In article <047AFD4B-8213-48C2-BB33-BCCC239F3147@microsoft.com>,
"Zip code help" <Zipcodehelp@discussions.microsoft.com> wrote:

> One of my files contains a field of Emails. I want to sort it by the ISP, not
> the beginning of the text. so if an email is none@aol.com, I want to sort it
> so I can view all the @aol.com,@hotmail.com, etc. -- the only way I know how
> to sort is by Ascending/descending and it sorts by the beginning of the text.
> Thanks!

On Fri, 14 Oct 2005 09:14:09 -0700, "Zip code help"
<Zipcodehelp@discussions.microsoft.com> wrote:

>One of my files contains a field of Emails. I want to sort it by the ISP, not
>the beginning of the text. so if an email is none@aol.com, I want to sort it
>so I can view all the @aol.com,@hotmail.com, etc. -- the only way I know how
>to sort is by Ascending/descending and it sorts by the beginning of the text.
>Thanks!

Use a helper column to extract the ISP. If email names are in A1 enter
in B1

=RIGHT(A12,LEN(A12)-FIND("@",A12))
copy down as appropriate then sort on column B

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________