Sorting list of email addresses

[saturnin02]

Hi,
I have a list of email addresses that I use for periodic mailings ant it is
currently sorted alphabetically.
However, I would like to sort the addresses based on domain name.
The addresses are each in one cell.

Cell A1
Name
Cell A2
(e-mail address removed)

I may have in the list: (e-mail address removed), (e-mail address removed), etc. in different
spots throughout the list based on the first letter of the email
addresses--alphabetically.

I want to group all users @mymail.com together--in separate cells and rows.

Any ideas?

Tx,
Sat

 

[Norman Jones]

Hi Saturnin,

Try: Data | Text to Columns | Delimited | Delimiters | Other @

 

[Guest]

However, if you want to keep the address as one field, for each address insert the formula:

=RIGHT(A1,LEN(A1)-FIND("@",A1,1)+1) where A1 is the cell that contains your address in an unused column.

This will create just the @...... part of the address in a separate cell. You can then do a normal sort using that range of ceels as the sort key.

unlikeKansas

 

[saturnin02]

Fantastic.
It works great--And I DID need to leave each address in one cell per address
to be able to export it easily, etc.
Very helpful.
Thanks to both of you.
Sat

However, if you want to keep the address as one field, for each address insert the formula:

=RIGHT(A1,LEN(A1)-FIND("@",A1,1)+1) where A1 is the cell that contains

your address in an unused column.

This will create just the @...... part of the address in a separate cell.

You can then do a normal sort using that range of ceels as the sort key.

 

[saturnin02]

Actually, Now that its is all sorted properly, is there a way to subtotal it
by DNS so that each group is collapsible and easy to separate?
That would help me in easily finding and getting tto the DNS group I want
and edit the addresses for example, etc.
Actually I have done this:
Select the range and use subtotal using count as the function and the column
containing the @mail.com as the factor.
Seems to work nicely.
Let me know if there is a better way.
Tx again

However, if you want to keep the address as one field, for each address insert the formula:

=RIGHT(A1,LEN(A1)-FIND("@",A1,1)+1) where A1 is the cell that contains

your address in an unused column.

This will create just the @...... part of the address in a separate cell.

You can then do a normal sort using that range of ceels as the sort key.

 

[Dave Peterson]

Did you type in that =subtotal() formula or did you sort your data first, then
apply Data|subtotals?

 

[saturnin02]

I sorted the data first using the sort function as descirbed in this thread
and then used the Data|Subtotals
......

 

[Dave Peterson]

That seems like the easiest way to me. (I wasn't sure if you typed in the
=subtotal() formulas yourself.)

 

[saturnin02]

OK. Tx.
S

That seems like the easiest way to me. (I wasn't sure if you typed in the
=subtotal() formulas yourself.)