There are couple of functions (Search and Find) which we can use to search the string in a Excel cell.
The main difference between Search and Find is Search is not a case sensitive.
If the Find/Search fails to find the given input string it will update with an error #VALUE other wise it returns the index of the string.
=ISERR(FIND("Find String","Its there in this Find String",1))
=ISERR(SEARCH("Find String","Its there in this Find String",1))
The main difference between Search and Find is Search is not a case sensitive.
If the Find/Search fails to find the given input string it will update with an error #VALUE other wise it returns the index of the string.
=ISERR(FIND("Find String","Its there in this Find String",1))
=ISERR(SEARCH("Find String","Its there in this Find String",1))
No comments:
Post a Comment