Organizing a column for what's after the @

  • Thread starter Thread starter Jorge E. Jaramillo
  • Start date Start date
J

Jorge E. Jaramillo

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
 
Use;

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

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