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