Hi,
Give it a try ...
formula is :
=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},D16&"01234 56789")),ROW(INDIRECT("1:"&LEN(A1)))))
HTH
Cheers
Carim
--
Carim
------------------------------------------------------------------------
Carim's Profile:
http://www.excelforum.com/member.php...o&userid=33259
View this thread:
http://www.excelforum.com/showthread...hreadid=536930