Q: search in string
 

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.

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.

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.

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.

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.

"Aladin Akyurek" wrote:

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.

Do you mean VBA?

If yes, take a look at InStr in VBA's help.



JIM.H. wrote:

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.

"Aladin Akyurek" wrote:

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.




--

Dave Peterson