Skip to content

FIND

TextExcel 2007

Position of one string inside another — case-sensitive, no wildcards.

Syntax

FIND(find_text, within_text, [start_num])

Arguments

find_text
The text to look for.
within_text
The text to search in.
start_numoptional
Character to start at. Default 1.

How it works

Returns #VALUE! if the text isn't found — wrap in IFERROR when that's expected.

Examples

=FIND("@", "[email protected]")

→ 6

Related functions

SEARCHTEXTBEFOREISNUMBER

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATCONCATENATEDBCSDOLLAREXACTFINDB

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.