Use instr inplace of find or before search

if instr(string1,",") 0 then
'put find or search here
end if

"RK" wrote:

When I try finding a text string within another test string (for exmaple
using "find" or "Search") it returns a value when the text string is found.
However, when the text string is not found it returns an Error ("#Value!").
I'd like to autmatically calulate the cell as "Y" if the text string was
found or "N" if it was not found.