Cool....Now you get to play with her Optiview!
I dunno what that is, but it sounds fun.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of MS Exchange
List
Sent: Thursday, September 20, 2001 3:04 PM
To: Exchange Discussions
Cc: 'Jennifer Baker'
Subject: 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)) - FIND("SMTP", C2)- 5))
(and my thanks to the original author of this formula!)
Brent
-----Original Message-----
From: Jennifer Baker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 2:55 PM
To: Exchange Discussions
Subject: parsing smtp address in csv
I know this has been asked before, but the link in faq 3.22 is dead and
was in my favorites: http://www.ncgroup.com/abu/exchange/formulas.htm
I knew I should have saved it to disk.
Anybody have the formula? I let you play with my optiview.
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
