I don't think that formula ignores letters, as such. If you have a
single number in A1 it will exract that, e.g. it will take 342 from
"xyz342abc". Is that what you want to do?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515128