string manipulation
 

Dear Friends,

does anyone has any piece of code that returns true is string
contains string B and false otherwise?

Thank you in advance.


--
Message posted from http://www.ExcelForum.com

string manipulation
 

Have a look at the INSTR() function.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"banavas " skrev i en meddelelse
...
Dear Friends,

does anyone has any piece of code that returns true is string A
contains string B and false otherwise?

Thank you in advance.
G


---
Message posted from http://www.ExcelForum.com/

string manipulation
 

Take a look at the InStr method in VBA Help. You can return True/False
with:

Dim bAcontainsB As Boolean
bAcontainsB = InStr(strA, strB) 0


In article ,
banavas wrote:

Dear Friends,

does anyone has any piece of code that returns true is string A
contains string B and false otherwise?