determine wheter string has a number in it?
 

Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?

determine wheter string has a number in it?
 

Let me clarify -- formula looks in A1 to determine whether or not a number is
in the string that is in A1.

For example

A1 = asfkajsf4asdf --- TRUE
A1 = asdlfksdfa ---- FALSE

"Ted Metro" wrote:

Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?

determine wheter string has a number in it?
 

With
A1 containing a value that may contain a number or be blank

This formula returns TRUE if A1 contains a number:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ted Metro" wrote:

Let me clarify -- formula looks in A1 to determine whether or not a number is
in the string that is in A1.

For example

A1 = asfkajsf4asdf --- TRUE
A1 = asdlfksdfa ---- FALSE

"Ted Metro" wrote:

Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?

determine wheter string has a number in it?
 

Try this:

=ISNUMBER(--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),1))

Biff

"Ted Metro" wrote in message
...
Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?

determine wheter string has a number in it?
 

Very much so Mr. C.

Thank you much!

"Ron Coderre" wrote:

With
A1 containing a value that may contain a number or be blank

This formula returns TRUE if A1 contains a number:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ted Metro" wrote:

Let me clarify -- formula looks in A1 to determine whether or not a number is
in the string that is in A1.

For example

A1 = asfkajsf4asdf --- TRUE
A1 = asdlfksdfa ---- FALSE

"Ted Metro" wrote:

Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?

determine wheter string has a number in it?
 

I'm glad that worked for you.....and thanks for the feedback (much appreciated)


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

XL2002, WinXP


"Ted Metro" wrote:

Very much so Mr. C.

Thank you much!

"Ron Coderre" wrote:

With
A1 containing a value that may contain a number or be blank

This formula returns TRUE if A1 contains a number:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ted Metro" wrote:

Let me clarify -- formula looks in A1 to determine whether or not a number is
in the string that is in A1.

For example

A1 = asfkajsf4asdf --- TRUE
A1 = asdlfksdfa ---- FALSE

"Ted Metro" wrote:

Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell?