FIND
Description
Searches the specified text string for a sub-string. Returns the starting position of
the find_text in the within_text. The search is case-sensitive. For case-insensitive
search, use SEARCH.
Syntax
FIND(
find_text
,
within_text
, [
start_num
])
- find_text: The text to find in the string.
- within_text: The text to search.
- start_num: The starting position for the search.
Example
Formula | Result |
|---|---|
=FIND("Sales",A1)
Where cell A1 contains
Regional Sales Manager
.
| 10 |