Excel FIND vs. SEARCH: Locate text in a cell
In Excel, FIND and SEARCH return the starting position of the matched text in the original string. Use FIND for a case-sensitive match. Use SEARCH to ignore case or match a wildcard pattern. Positions start at 1.
Set the search text, source, and starting position
The first argument is what to find. The second is the text or cell to search. The optional third argument is the character position where Excel starts looking and defaults to 1. Your regional settings may use semicolons in formulas where another locale uses commas.
Microsoft’s SEARCH function documentation
Compare case and starting position
Enter ABCDE in A2 and ABCDABCD in A3. Enter the formulas in the first table in separate blank cells. The two B characters in A3 are at positions 2 and 6. Starting at position 3 skips the first B, and the result is still 6, counted from the beginning of A3.
| Formula | Result |
|---|---|
=FIND("C",A2) |
3 |
=FIND("c",A2) |
#VALUE! |
=SEARCH("c",A2) |
3 |
=FIND("B",A3,3) |
6 |
Find patterns and literal symbols
Enter P-AB7* in A4. In SEARCH, a question mark (?) matches exactly one character and an asterisk (*) matches any sequence, including an empty sequence. Put a tilde (~) before either symbol to find the actual character. FIND treats asterisks and question marks as literal characters.
| Formula | Result |
|---|---|
=SEARCH("AB?",A4) |
3 |
=SEARCH("AB*",A4) |
3 |
=SEARCH("~*",A4) |
6 |
=FIND("*",A4) |
6 |
In the second table, AB? matches AB7 starting with A at position 3. Both ~* in SEARCH and * in FIND locate the literal asterisk at position 6.
Diagnose errors and review FINDB and SEARCHB
Excel returns a value error when the text is missing or the start is below 1 or beyond the text length. Check the target and start position first. With FIND, check the case as well.
FINDB and SEARCHB are legacy byte-based functions. In environments with a double-byte character set language configured as the default editing language, relevant characters can count as two. This can differ from a UTF-8 byte count. Use FIND or SEARCH for new formulas that need character positions, and verify existing formulas with representative text and the workbook’s editing environment.




