SEARCH
Description
Searches the specified text string for a sub-string. Returns the position of the find_text in the within_text. The search is not case-sensitive. For case-sensitive search, use FIND.
Syntax
SEARCH(
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 |
|---|---|
=SEARCH("sales",A1)
Where cell A1 contains
Regional Sales Manager
.
| 10 |