RE: parsing smtp address in csv

2001-09-20 Thread Martin Blackstone
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

RE: parsing smtp address in csv

2001-09-20 Thread MS Exchange List
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---