Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I handle error conditions with the FIND command?
I have a file of text strings in which some of the strings have a
substring I'm looking for, and others don't. I tried using the FIND command to determine if the substring exists for each text string, but when it doesn't ... I get #VALUE! returned. I would have assumed that since FIND returns the index of the substring, I would get something nice like "-1" returned when it's not there. The problem is ... how do I manage the #VALUE! returns? I mean, is that some kind of value I can test for? For instance, if I wanted to just list the index of the substring, or write a "0" if it's not there, I would try something like ... =IF(FIND(substring,string,1)0,FIND(substring,stri ng,1),0) But of course, it doesn't work. Can anyone help me? Thanks! Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing NULL Command Bar handle | Excel Discussion (Misc queries) | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
excel command that counts conditions met in 2 columns? | Excel Discussion (Misc queries) | |||
Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |