FIND / SEARCH find nonnumeric

How can I find the position of the first non-numeric carachter in a string.
Cell with 123B45 or 1234B5 How can I find the posiion of "B"

FIND & SEARCH only find an exact match not a range >= A
help please

Originally Posted by Barry Staples

How can I find the position of the first non-numeric carachter in a string.
Cell with 123B45 or 1234B5 How can I find the posiion of "B"

FIND & SEARCH only find an exact match not a range >= A
help please

Check you previous post

http://www.excelforum.com/showthread.php?t=579551