=MID(A1,FIND(":",A1,FIND("%SMTP:",A1)+1)+1,FIND("% ",A1,FIND("%SMTP:",A1)+1)-
FIND(":",A1,FIND("%SMTP:",A1)+1)-1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"sixbeforedawn"
wrote in message
news:sixbeforedawn.1xecud_1130141128.6472@excelfor um-nospam.com...
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