If a cell contains a number digit

[pauldaddyadams]

Hi

I would like an if formula which looks in a cell and if it contains any digit thrn it returns "yes" if not "no"

e.g. 1:
'AC680000

Would return "Yes"

e.g. 2:

'EXTINC

Would return "No"

Can anyone help please?

[NeedForExcel]

If your Input Text/Number is on Cell A1, Put this in B1

=IF(SUM(IFERROR(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1)+0,0))>0,"Yes","No")

Commit using Ctrl+Shift+Enter

[Special-K]

This seems to work but not how I was expecting

=IF(SUM(ISNUMBER(SEARCH({"0","1","2","3","4","5","6","7","8","9"},A1))+0)<>0,"Yes","No")

[XOR LX]

You can also use:

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

Regards

[pauldaddyadams]

Thanks all, all 3 worked

[NeedForExcel]

@pauldaddyadams

Special-K & XOR have better solutions because they are Non-Array Formulas & do not use Volatile Functions..

Go for those..