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

format and display text values. Use FIND to Finds text position (case-sensitive). use "@" for find_text, use C2 for within_text, use 1 for start_num. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=FIND("@", C2, 1)

Practice This Function

Practice in Sequential Mode Back to Function List