Finding cells with numbers
Hi all,
Does anyone know if there's a way to structure an if statement like:
IF(cell A1 contains a number),show cell A1,leave default FALSE
I've tried wildcards and I can't figure it out. I want to be able to make
this work if any number 0-9 is the first character in the cell, so it would
catch things like:
1
1939
20/20
1024-bit
but not things like:
Route 90
T1000 (I'm a T2 fan, can you tell? :) )
Thanks a lot!
jezzica85
|