Hi - Dave here.
What formula will tell you if password contains a number?
This is a surprisingly tricky problem because Excel doesn't have a function that will let you test for a number inside a text string directly.
One option is to use the FIND function to look for all 10 numbers, then count the results, as seen in the worksheet below. The formula in cell C5 is:
=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},B5))>0
[
download the workbook and read the full explanation]
This is a good example of how formulas in Excel are not always obvious. Click the link above for a full explanation. I also included an alternate formula you can use in Excel 365 based on the SEQUENCE function. Download the workbook and have a look.
Gift idea
Need a gift for the Excel nerd in your life? We have a nice
laminated card with over 200 Excel shortcuts for both Windows and Mac.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
