Q: search in string

J

JIM.H.

Hello,
How would you search a string from another and check the return code. I was
using Search(), excel does not recognize it.
Thanks,
Jim.
 
J

JIM.H.

retValue = Search("X", "XXXX", 1)
I get Sun or Function not defined on Search when I try to run it.
 
A

Aladin Akyurek

Not sure where you're heading, maybe:

=ISNUMBER(SEARCH("X","XXXX"))

would return TRUE if the substring "X" is part of the string "XXXX",
otherwise FALSE.
 
J

JIM.H.

Thanks Aladin. I am trying to search string in a string in the module in
excel, not in the cell. It works in the cell, but not working in the module.
 
Top