Hi

I need to extract the SMTP's from an Exchange export, I've been tring
to do it using MID but not having much luck

the string looks like this.

CCMAIL:secondname, firstname at
%X400:c= Country;a=
;p=domain;o=domainLON;s=secondname;g=firstname;

and what I want to extract is

can't seem to be able to start the extract at SMTP: and then end it at
%X400.

can anybody help?

TIA a newbie :)


--
sixbeforedawn
------------------------------------------------------------------------
sixbeforedawn's Profile: http://www.excelforum.com/member.php...o&userid=28297
View this thread: http://www.excelforum.com/showthread...hreadid=478699