Prev: Retrospective Cell Naming
Next: I want to link sheets in excel to a master sheet in excel
From: Jorge E. Jaramillo on 7 Apr 2010 22:13
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
From: ozgrid.com on 7 Apr 2010 22:25
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" <JorgeEJaramillo(a)discussions.microsoft.com> wrote in
message news:18B9027C-531B-44B1-89FD-53313E97B35F(a)microsoft.com...
>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

From: Jorge E. Jaramillo on 8 Apr 2010 08:35
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" <JorgeEJaramillo(a)discussions.microsoft.com> wrote in
> message news:18B9027C-531B-44B1-89FD-53313E97B35F(a)microsoft.com...
> >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
>
 | 
Pages: 1
Prev: Retrospective Cell Naming
Next: I want to link sheets in excel to a master sheet in excel