Extract sub string
 

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 :confused:

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

Extract sub string
 

=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 :confused:

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

Extract sub string
 

sorted it ;)


=MID(A1, SEARCH("%smtp:",A1)+6, (SEARCH("%X400",A1)-6 -
SEARCH("%SMTP:",A1)))

Cheers


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