Excel Function

SEARCH

Finds text position (case-insensitive).

SEARCH(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 SEARCH to Finds text position (case-insensitive). 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

=SEARCH("@", C2, 1)

Practice This Function

Practice in Sequential Mode Back to Function List