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