Forum Discussion
Finding a number in a text string
I have test strings from 3 to 7 characters, one of which is a number 0-9. The number is not in the same place but may be in the first to third position. How can I have a cell report that number’s posi...
Try this one:
=SUM(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1,1),""))
..... where A1 is your text string.
On drawback though. If your text string has more than one numerical digit in it, it will not work 😞