G
Guest
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. (e-mail address removed),[email protected], - > remove the second one or the first one(between the
2 email ids there will chances of comma or / )
2. (e-mail address removed), - > 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
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. (e-mail address removed),[email protected], - > remove the second one or the first one(between the
2 email ids there will chances of comma or / )
2. (e-mail address removed), - > 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