Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Plsss
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Plsss
=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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Plsss
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|