if cell A1 contains the text string "bob 18/1/06 fred 24/1/06 dick" you
can search for a number between 0 and 9 , this will return the position
of the various numbers within the string. Use the lowest number.
LEN(A1) will give you the string length, can you work with this?


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=547812