Alphanumeric 'ISNUMBER' formula to return 'Yes' or 'No'

[RuthieBuxton]

I have ISNUMBER formulas returning 'Yes' or 'No' and working well (=IF(ISNUMBER(Dashboard!DH6),"Yes","No")). However there are cells with Alphanumeric numbers e.g. JB4LW4J, 5HQ6LK1 etc. and the ISNUMBER formula doesn't work. I don't want or need to split the alphanumeric numbers. If a cell contains an alphanumeric number then I need it to return 'Yes' or 'No'.

Can anyone help please?

[etaf]

so does that mean - you actually only need to see if the cell is blank ?

yes or no for alpha and for numbers - covers most entries

[AndyLitch]

Are you saying you want it to recognise anything with a numeric digit as a number ?

[Kevin UK]

Hi RuthieBuxton

Try the following.

=IF(ISNUMBER(SEARCH({1,2,3,4,5,6,7,8,9,0},Dashboard!DH6&1234567890)),"Yes","No")

[Jonmo1]

Try

=IF(ISNUMBER(LOOKUP(2^15,SEARCH({0,1,2,3,4,5,6,7,8,9},Dashboard!DH6))),"yes","No")

[RuthieBuxton]

Kevin UK, that was perfect! Thank you very much. You've saved me about ½ day

[Jonmo1]

Hi RuthieBuxton

Try the following.

=IF(ISNUMBER(SEARCH({1,2,3,4,5,6,7,8,9,0},Dashboard!DH6&1234567890)),"Yes","No")

That seems to return "yes" for ANY entry, even straight text like "Hello"

[Tony Valko]

If you want to know if a cell contains ANY digit anywhere within the cell try this:

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},Dashboard!DH6)),"Yes","No")

[Tony Valko]

Hi RuthieBuxton

Try the following.

=IF(ISNUMBER(SEARCH({1,2,3,4,5,6,7,8,9,0},Dashboard!DH6&1234567890)),"Yes","No")

That will always return Yes (except if the cell contains an error value).

[RuthieBuxton]

Thanks Jonmo1 and Tony. I did amend it slightly removing the numbers after the 'DH6'. It returned both yes and no after that. Tony, I'll try the formula you've provided too as I've come across another issue.

Thank you both for your help. Much appreciated

[Kevin UK]

Hi
My fault, should be.
=IF(ISNUMBER(LOOKUP(20^20,SEARCH({1,2,3,4,5,6,7,8,9},Dashboard!DH6))),"Yes","No")

Sorry.

[Tony Valko]

=IF(ISNUMBER(LOOKUP(20^20,SEARCH({1,2,3,4,5,6,7,8,9},Dashboard!DH6))),"Yes","No")

Don't mean to rub it in but I think you forgot to include 0 in the number array.

[Tony Valko]

Just let us know if you need further assistance on this.