![]() ![]() =SEARCH("market", "supermarket") returns 6 because the substring "market" begins at the 6 th character of the word "supermarket". Unlike FIND, the SEARCH function is case-insensitive and it allows using the wildcard characters, as demonstrated in the following example.Īnd here's a couple of basic Excel SEARCH formulas: Is syntax and arguments are akin to those of FIND: The SEARCH function in Excel is very similar to FIND in that it also returns the location of a substring in a text string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |