>Doyle,
>
>>I'm looking for a function to locate the occurance of a number within a character string such as AT(). Thhanks to all.
>
>Please explain in more detail what you need. Do you mean you want to find "675" in a character string, or you want to find the first numeral in a character string, or look for all the 9's, or what?

Try VAL(mystring)

mystring = "ABCD2345DEFG"

VAL(mystring) = 2345!