Help Plsss

Hi All,

I have =MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)
to trim the emal Ids like Madhan <[email protected]>. now I want to add one
thing to that I want to trim the below email types also.
1. [email protected],[email protected], - > remove the second one or the first one(between the
2 email ids there will chances of comma or / )

2. [email protected], - > remove the comma(it might be comma or > or < or /)

it would be very helpful if any one could help me out with this (either in
Macro or in Cell formula).

Many Thanx in Advance.
Madhan

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
IF(ISNUMBER(FIND(",",A11)),IF(LEFT(A11,FIND(",",A11)-1)=RIGHT(A11,LEN(A11)-F
IND(",",A11)),LEFT(A11,FIND(",",A11)-1),A11),A11),
"<",""),
">",""),
",","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vmadan16" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I have =MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)
> to trim the emal Ids like Madhan <[email protected]>. now I want to add one
> thing to that I want to trim the below email types also.
> 1. [email protected],[email protected], - > remove the second one or the first one(between
the
> 2 email ids there will chances of comma or / )
>
> 2. [email protected], - > remove the comma(it might be comma or > or < or /)
>
> it would be very helpful if any one could help me out with this (either in
> Macro or in Cell formula).
>
> Many Thanx in Advance.
> Madhan
>
>

Hi Bob,

Thanx a lot man, i dont have words to say. Thanx thanx

Regards
Madhan

"Bob Phillips" wrote:

> =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
> IF(ISNUMBER(FIND(",",A11)),IF(LEFT(A11,FIND(",",A11)-1)=RIGHT(A11,LEN(A11)-F
> IND(",",A11)),LEFT(A11,FIND(",",A11)-1),A11),A11),
> "<",""),
> ">",""),
> ",","")
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "vmadan16" <[email protected]> wrote in message
> news:[email protected]...
> > Hi All,
> >
> > I have =MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)
> > to trim the emal Ids like Madhan <[email protected]>. now I want to add one
> > thing to that I want to trim the below email types also.
> > 1. [email protected],[email protected], - > remove the second one or the first one(between
> the
> > 2 email ids there will chances of comma or / )
> >
> > 2. [email protected], - > remove the comma(it might be comma or > or < or /)
> >
> > it would be very helpful if any one could help me out with this (either in
> > Macro or in Cell formula).
> >
> > Many Thanx in Advance.
> > Madhan
> >
> >
>
>
>