Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Im trying to identify cells that contain certain text using isnumber. I have
a column (M) that contains UK postcodes such as ST6 2JH, DE22 1BH, YO18 5DS and many more etc. By using =ISNUMBER(SEARCH("YO",M2)) I am able to find the YO in cell N2 but I need to expand it to find other postcodes as well, e.g. DE. Column N should be able to state "True" when DE or YO is identified. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If, And, Isnumber statement | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
isnumber with sumproduct | Excel Worksheet Functions |