Returns the position at which a string is first found within text, case-sensitive.
FIND("wood","How much wood can a woodchuck chuck",14)
FIND(search_for, text_to_search, [starting_at])
search_for- The string to look for within
text_to_search- The text to search for the first occurrence of
starting_at- [ OPTIONAL -
1by default ] - The character within
text_to_searchat which to start the search.
FINDis case-sensitive, meaning that uppercase and lowercase letters matter. For example, "abc" will not match "ABC". To ignore case, use the
- Ensure that
text_to_searchare not supplied in reverse order, or the
#VALUE!error will likely be returned. The arguments are supplied in a different order than other text functions such as
- It's recommended to use a function such as
IFERRORto check for cases when there aren't matches to the search.
SUBSTITUTE: Replaces existing text with new text in a string.
SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
SEARCH: Returns the position at which a string is first found within text, ignoring case.
IFERROR: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.
In order to use the FIND formula, start with your edited Excellentable:
Then type in the FIND formula in the area you would like to display the outcome:
By adding the values you would like to calculate the FIND formula for, Excellentable will generate the outcome: