FIND function
FIND returns the position where one piece of text first appears inside another. It is case-sensitive and does not allow wildcards, so use SEARCH if you need either.
Example
Read it as a sentence: find the position of the first c inside abcabc, which gives 3.
A
B
C
D
1
3
2
3
Syntax
FIND(find_text, within_text, [start_num])
Arguments in [square brackets] are optional.
-
find_text(required) - The text to look for.
-
within_text(required) - The text to search in.
-
start_num(optional) - Position to begin searching; default 1.
Returns: The position of the first match, or #VALUE! if not found.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FIND("b","abc") | 2 | Basic |
=FIND("","abc") | 1 | Empty find text |
=FIND("c","abc",3) | 3 | Start at match |
=FIND("","abc",4) | 4 | Empty find, start = len+1 |
=FIND("?","a?c") | 2 | Wildcard is literal |
=FIND(1,12341,2) | 5 | Numbers |
=FIND("B","abc") | #VALUE! | Case-sensitive |
=FIND("c","abc",4) | #VALUE! | Start past match |
Watch out for
- Case-sensitive.
- Returns #VALUE! when nothing is found; wrap in IFERROR.
Where it works
- Excel
- FIND is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .