=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. Start_num is 0 (zero) or a negative number.Start_num contains more characters than within_text.Find_text does not exist in within_text.The Excel FIND function returns the #VALUE! error if any of the following occurs:.If find_text is an empty string "", the Excel FIND formula returns the first character in the search string.For example, FIND("l", "hello") returns 3, which is the position of the first "l" character in the word "hello". If within_text contains several occurrences of find_text, the first occurrence is returned.For example, the formula FIND("ap","happy") returns 2 because "a" in the 2 nd letter in the word "happy". If the find_text argument contains several characters, the FIND function returns the position of the first character.
The formula =FIND("a", "find") returns an error because there is no "a" in " find".Įxcel FIND function - things to remember! If the FIND function does not find the find_text character(s), a #VALUE! error is returned.įor example, the formula =FIND("d", "find") returns 4 because "d" is the 4 th letter in the word " find". If omitted, the search starts from the 1 st character of the within_text string. Start_num - an optional argument that specifies from which character the search shall begin.Usually it's supplied as a cell reference, but you can also type the string directly in the formula. Within_text - the text string to be searched within.Find_text - the character or substring you want to find.The first 2 arguments are required, the last one is optional.
We recommend that you change your password after you log in for the first time.Email address: Password: Te Kura Student ID number.Open your internet browser and go to the Microsoft login page.You must set up your Te Kura email account before you can download the Microsoft software. What’s more, you can use Microsoft OneDrive to automatically sync your devices.
You can install Microsoft Office 365 Pro Plus on up to five compatible PCs and Macs, plus five tablets (including iPad).