Q: search in string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
retValue = Search("X", "XXXX", 1)
I get Sun or Function not defined on Search when I try to run it.
 
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.
 
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.
 
Do you mean VBA?

If yes, take a look at InStr in VBA's help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to search Excel files based on a specific text string in VBA c 1
Nested String Search and Return Value. 3
vba code help for multiple string searching 0
How to sort data in excel 2000? 3
How do I sort data in PivotTables in Excel 2000? 1
Search for string of characters in a cell 3
File Download - Security Warning 5
Search for string containing 5

Back
Top