View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default 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