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

AB
1Menu nameFound at
2Thai Coffee6

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.

Source: support.microsoft.com

Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile