ubject: RE: parsing smtp address in csv
Hello,
I think this is what you're looking for:
=MID(C2, FIND("SMTP",C2) + 5,
IF(ISERROR(FIND("%",C2,FIND("SMTP",C2))),LEN(C2) - FIND("SMTP", C2) -4,
FIND("%", C2, FIND("SMTP", C2)) - F
Hello,
I think this is what you're looking for:
=MID(C2, FIND("SMTP",C2) + 5,
IF(ISERROR(FIND("%",C2,FIND("SMTP",C2))),LEN(C2) - FIND("SMTP", C2) -4,
FIND("%", C2, FIND("SMTP", C2)) - FIND("SMTP", C2)- 5))
(and my thanks to the original author of this formula!)
Brent
-Original Message---
2 matches
Mail list logo