Excel SEARCH function🔤 Find position (any case)
The SEARCH function: Find position (any case). Check if text contains a word (with ISNUMBER). This page shows the syntax, a worked example with its result and how the formula reads.
What does SEARCH do?
Find position (any case). Check if text contains a word (with ISNUMBER)
SEARCH syntax
=SEARCH(find_text, within_text, [start_num])
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
SEARCH example with the result
=********
👑 Ready-to-use example formula for VIP supporters only · Become VIP
Formula in cell B2 Yellow cells = result
| A | B | |
|---|---|---|
| 1 | Menu name | Found at |
| 2 | Thai Coffee | 6 |
How it reads: Finds coffee in any case, at character 6 · not found gives #VALUE!
Frequently asked questions about SEARCH
What does SEARCH do?
Find position (any case). Check if text contains a word (with ISNUMBER)
What does the SEARCH example return?
The example formula in cell B2 gives 6.
Which Excel versions have SEARCH?
It has been in Excel for many versions and works in the versions in common use today, including Excel for Microsoft 365.
🕸️ More text formulas and related ones
Source: support.microsoft.com
Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning