Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Segregating a Search String | Excel Discussion (Misc queries) | |||
Excel 2000 - How to create an auto search | Excel Discussion (Misc queries) | |||
Search for a Sheet | Excel Discussion (Misc queries) | |||
better search: "make worksheet visible" | Excel Discussion (Misc queries) |