View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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