CONTAINS

Returns whether a string is contained inside another string.

text1The text string containing your substring.
text2The 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".


microsoft excel docs

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext