this would give you the 10 digit number after the word details:
=MID(A1,FIND("00",A1,FIND("DETAILS",A1,1)),10)


is there any thing that's always the same in these strings?
--


Gary


"spectator" wrote
in message ...

and to nickhk i am trying to get the second one. Thanks!


--
spectator
------------------------------------------------------------------------
spectator's Profile:
http://www.excelforum.com/member.php...o&userid=25635
View this thread: http://www.excelforum.com/showthread...hreadid=390454