Thread
:
Help Plsss
View Single Post
#
1
Posted to microsoft.public.excel.programming
vmadan16
external usenet poster
Posts: 18
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
Reply With Quote
vmadan16
View Public Profile
Find all posts by vmadan16