Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Organizing Charts | Charts and Charting in Excel | |||
Need Help Organizing a Formula? | Excel Worksheet Functions | |||
Help organizing date | Excel Discussion (Misc queries) | |||
Help with organizing data | Excel Discussion (Misc queries) | |||
Organizing Data | Excel Worksheet Functions |