A couple of guys answered this in the MS Office forum. If this has been a problem for anyone else, the formula in excel is:
=MID(A14,FIND("SMTP:",A14),(FIND("%",A14,FIND("SMTP:",A14))-FIND("SMTP:",A14)))
Substitute A14 for the field that the 'e-mail...