Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text
Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in free-format text field | Excel Discussion (Misc queries) | |||
Find repeated text in a text document in Excel | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) |