| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND function does not return ZERO when text is not found
Why does the FIND("search text", "within text"[,start position]) function
return "#VALUE" instead of ZERO (0) when the search text is not in the 'within' string? #VALUE does not make sense as a result. If the text exists the result will be its position which can not be less than 1. If it doesn't exist then Zero indicates no position. Further How can I get a ZERO result from FIND()? I am using Excel 2003. The INSTR('find-text','within-text','start') function used to return Zero but the function is not available in 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return text value found most frequently in a column | Excel Worksheet Functions | |||
| "No RETURN() or HALT() function found on macro sheet." | Excel Worksheet Functions | |||
| No RETURN() or HALT() function found on macro sheet | Excel Discussion (Misc queries) | |||
| Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) | |||
| Return text found in a search | Excel Worksheet Functions | |||
Threaded Mode
