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