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 |