CONTAINS
Returns whether a string is contained inside another string.
| text1 | The text string containing your substring. |
| text2 | The text string to look for. |
| ignore_case | (Optional) Whether you want to ignore the case of the text. |
Remarks
* If "IgnoreCase" is left blank, then False is used.
* This function can include wildcards.
* The equivalent VBA function is CONTAINS
| | A | | 1 | =JS.CONTAINS("text","sometext") | | 2 | =JS.CONTAINS("TEXT","sometext",TRUE) | | 3 | =JS.CONTAINS("TEXT","sometext",FALSE) | | 4 | =JS.CONTAINS("one","londoner") |
|
1 - Does the text "some text" contain the substring "text".
