Download workbook: : http://ift.tt/2xTElyv
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use Flash Fill, Formula or VBA to detect when Text cell value contains number digits. Meni Porat also has a great formula that uses COUNT, SEARCH and IF.
Topics:
2) (00:01) Dueling Song
3) (00:28) Introduction to Topic
4) (00:55) Flash Fill example (Mr Excel)
5) (02:17) Formula example using SUBSTITUTE, AND and IF Functions with an Array Constant (excelisfun)
6) (06:39) Meni Porat also has a great formula that uses COUNT, SEARCH and IF (Meni Porat)
7) (10:52) VBA Code to create UDF function (Mr Excel)
8) (11:40) Wrap up and conclusion
Excel Duel, Dueling Excel, Excel Duel 186