Is there a find or search function that will return the position of the
first number character within a cell?

for example

A1= TEST PRODUCT M123

is there a formula i could write that will return "15" being that is
the posistion in the cell that the "1" is in? I dont want to look for
the "1" in particular, just the first number in the cell.

thanks!


--
shineboxnj
------------------------------------------------------------------------
shineboxnj's Profile: http://www.excelforum.com/member.php...o&userid=18106
View this thread: http://www.excelforum.com/showthread...hreadid=389217