find number position in excel text cell
Try something like this:
For a value in A1
B1: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )
If A1: wavc1asd
the formula returns 5 (the number is in the 5th position)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Don" wrote:
I have a spreadsheet with a column of amatuer radio call signs that consist
of a numerical digit in text. The text string can vary in length and the
numbers position can also vary within the text. I would like to find the
position of the number in the text. Any help is appreciated.
Thanks
Don
|