ExcelBanter - Help Plsss

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help Plsss (https://www.excelbanter.com/excel-programming/366401-help-plsss.html)

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
IF(ISNUMBER(FIND(",",A11)),IF(LEFT(A11,FIND(",",A1 1)-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" wrote in message
...
Hi All,

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

2. , - 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(",",A1 1)-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" wrote in message
...
Hi All,

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

2. , - 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