Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I use "VLOOKUP" with cells containing both Text & Numbers? | Excel Worksheet Functions | |||
Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) |