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.
JIM.H. wrote:
retValue = Search("X", "XXXX", 1)
I get Sun or Function not defined on Search when I try to run it.
"Aladin Akyurek" wrote:
Would you post the formula along with the values involved?
JIM.H. wrote:
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.
|