Excel Function

FIND

Finds text position (case-sensitive).

FIND(find_text, within_text, [start_num])

Arguments

find_text

Required

Enter a text value (wrap with quotes when needed).

within_text

Required

Enter a text value (wrap with quotes when needed).

start_num

Optional

Enter a numeric value.

Practice Preview

Use FIND to return the result with these settings (Find text: "@", Within text: C2 (cell C2 (Email in column C)), Start position: 1).

Example Table

#	AEmployee ID	BName	CEmail	DPayment Amount	EAmount Text
2	E001	Taro Tanaka	t.tanaka@example.com	1200	1200
3	E002	Hanako Suzuki	h.suzuki@example.com	980	980
4	E003	Ken Sato	k.sato@example.com	2450	2450
5	E004	Aya Takahashi	a.takahashi@example.com	3000	3000
6
7
8

How to Use (Formula)

=FIND("@", C2, 1)

Result

Practice This Function

Start Function Practice Back to Function List

FIND FAQ

How do I use FIND in Excel?

Use FIND when you want to find character positions with case sensitivity. Enter Find text, Within text, Start position in that order, then add optional arguments when needed.

Where can I practice FIND?

Use the "Start Function Practice" button to jump straight into FIND drills.

What arguments does FIND use?

The main arguments are Find text, Within text, Start position. Start with the required ones, then add optional arguments if needed.