0In excel there are two functions which are taking same arguments and return type.
SEARCH() --> Search a text within text, Case insensitive
- Example: Search("t","Management Team") and Search("T","Management Team") both will return same position i.e. 10
FIND() --> Find a text within text, Case sensitive i.e. Search("t","Management Team") and Search("T","Management Team") both will return same position ie
- Example: Search("t","Management Team") and Search("T","Management Team") both will return differenct position i.e.
- Find("t","Management Team") will return 10
- Find("T","Management Team") will return 12
Same functions can be used in excel vba macro also using WorksheetFunction.Search and WorksheetFunction.Find
