software

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

Try something like this:

For a value in A1
B1: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;0123456789quot;) )

If A1: wavc1asd
the formula returns 5 (the number is in the 5th position)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Donquot; wrote:

gt; I have a spreadsheet with a column of amatuer radio call signs that consist
gt; of a numerical digit in text. The text string can vary in length and the
gt; numbers position can also vary within the text. I would like to find the
gt; position of the number in the text. Any help is appreciated.
gt; Thanks
gt; Don

Ron,
That does find the position number of the number but when I try to use it
in my function it returns a #VALUE error . I saved the position number in
column P and have tryed to convert text to number just in case that was the
problem. Here is the code I am trying to use:
=RIGHT(CALL,(LEN(CALL)-FIND(P2,CALL,1)))

Again thanks for the help and the quick response.

Don
quot;Ron Coderrequot; wrote:

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

If you're trying to pull from the 1st number to the end of the string in the
cell named CALL, try this:

=MID(CALL,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;012 3456789quot;)),255)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Donquot; wrote:

gt; Ron,
gt; That does find the position number of the number but when I try to use it
gt; in my function it returns a #VALUE error . I saved the position number in
gt; column P and have tryed to convert text to number just in case that was the
gt; problem. Here is the code I am trying to use:
gt; =RIGHT(CALL,(LEN(CALL)-FIND(P2,CALL,1)))
gt;
gt; Again thanks for the help and the quick response.
gt;
gt; Don
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try something like this:
gt; gt;
gt; gt; For a value in A1
gt; gt; B1: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;0123456789quot;) )
gt; gt;
gt; gt; If A1: wavc1asd
gt; gt; the formula returns 5 (the number is in the 5th position)
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Donquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with a column of amatuer radio call signs that consist
gt; gt; gt; of a numerical digit in text. The text string can vary in length and the
gt; gt; gt; numbers position can also vary within the text. I would like to find the
gt; gt; gt; position of the number in the text. Any help is appreciated.
gt; gt; gt; Thanks
gt; gt; gt; Don

If you only want the letters after the 1st digit in the string, then how
about this:

=MID(CALL,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;012 3456789quot;)) 1,255)

Am I on the right track here?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Donquot; wrote:

gt; Ron,
gt; That does find the position number of the number but when I try to use it
gt; in my function it returns a #VALUE error . I saved the position number in
gt; column P and have tryed to convert text to number just in case that was the
gt; problem. Here is the code I am trying to use:
gt; =RIGHT(CALL,(LEN(CALL)-FIND(P2,CALL,1)))
gt;
gt; Again thanks for the help and the quick response.
gt;
gt; Don
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try something like this:
gt; gt;
gt; gt; For a value in A1
gt; gt; B1: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;0123456789quot;) )
gt; gt;
gt; gt; If A1: wavc1asd
gt; gt; the formula returns 5 (the number is in the 5th position)
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Donquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with a column of amatuer radio call signs that consist
gt; gt; gt; of a numerical digit in text. The text string can vary in length and the
gt; gt; gt; numbers position can also vary within the text. I would like to find the
gt; gt; gt; position of the number in the text. Any help is appreciated.
gt; gt; gt; Thanks
gt; gt; gt; Don

Ron,
I was able to make it work thanks to your help. Here is what I came up
with to make it work:

=RIGHT(CALL,(LEN(CALL)-((MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C4amp;quot;0123456789quot; ))))))

This gives me exatly what I want.
Thank you very much.

Don

quot;Ron Coderrequot; wrote:

gt; If you only want the letters after the 1st digit in the string, then how
gt; about this:
gt;
gt; =MID(CALL,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;012 3456789quot;)) 1,255)
gt;
gt; Am I on the right track here?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Donquot; wrote:
gt;
gt; gt; Ron,
gt; gt; That does find the position number of the number but when I try to use it
gt; gt; in my function it returns a #VALUE error . I saved the position number in
gt; gt; column P and have tryed to convert text to number just in case that was the
gt; gt; problem. Here is the code I am trying to use:
gt; gt; =RIGHT(CALL,(LEN(CALL)-FIND(P2,CALL,1)))
gt; gt;
gt; gt; Again thanks for the help and the quick response.
gt; gt;
gt; gt; Don
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Try something like this:
gt; gt; gt;
gt; gt; gt; For a value in A1
gt; gt; gt; B1: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;quot;0123456789quot;) )
gt; gt; gt;
gt; gt; gt; If A1: wavc1asd
gt; gt; gt; the formula returns 5 (the number is in the 5th position)
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Donquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet with a column of amatuer radio call signs that consist
gt; gt; gt; gt; of a numerical digit in text. The text string can vary in length and the
gt; gt; gt; gt; numbers position can also vary within the text. I would like to find the
gt; gt; gt; gt; position of the number in the text. Any help is appreciated.
gt; gt; gt; gt; Thanks
gt; gt; gt; gt; Don