Organizing a column for what's after the @
 

I have a table with a 2 columns, in one there are the names of people and on
the other one there are the email addresses of those people. Addresses and
people have been gathered through some time and they have no specific order.
Some of them work for the same organizations and I would like to send the
same email to the people of the same company.

So my question is, is there a way to organize the columns according to the
server of the email addresses?

Thanks in advance

Jorge E Jaramillo

Organizing a column for what's after the @
 

Use;

=MID(A1,FIND("@",A1)+1,256)

To extract the domain name and then sort by that Column.



--
Regards
Dave Hawley
www.ozgrid.com
"Jorge E. Jaramillo" wrote in
message ...
I have a table with a 2 columns, in one there are the names of people and
on
the other one there are the email addresses of those people. Addresses and
people have been gathered through some time and they have no specific
order.
Some of them work for the same organizations and I would like to send the
same email to the people of the same company.

So my question is, is there a way to organize the columns according to the
server of the email addresses?

Thanks in advance

Jorge E Jaramillo

Organizing a column for what's after the @
 

It worked perfeclty, thanks a lot.

Jorge Jaramillo

"ozgrid.com" wrote:

Use;

=MID(A1,FIND("@",A1)+1,256)

To extract the domain name and then sort by that Column.



--
Regards
Dave Hawley
www.ozgrid.com
"Jorge E. Jaramillo" wrote in
message ...
I have a table with a 2 columns, in one there are the names of people and
on
the other one there are the email addresses of those people. Addresses and
people have been gathered through some time and they have no specific
order.
Some of them work for the same organizations and I would like to send the
same email to the people of the same company.

So my question is, is there a way to organize the columns according to the
server of the email addresses?

Thanks in advance

Jorge E Jaramillo