Excel SEARCH Function Generator

Find the position of substring in the given string - Case-insensitive

Find Text (Substring to search for): Enter the substring or cell reference you want to locate. Example: "apple" or C10.

Within Text (Text to search within): Enter the text string or cell reference where you want to search. Example: "I like apples" or B5.

Start Number (Optional): Specify the position to start the search (default is 1). Example: 1.

Wildcard Options:

None

Use "?" (Matches any single character)

Use "*" (Matches any sequence of characters)

=SEARCH()

Scenario	Formula	Result
Find the position of "m" in "Mango"	=SEARCH("m", "Mango")	1 (FIND produces an error)
Find "e" in "Elephant"	=SEARCH("e", "Elephant")	2 (First occurrence)
Locate "o" in "Hello World"	=SEARCH("o", "Hello World")	5
Find "o" in "Hello World" starting from position 6	=SEARCH("o", "Hello World", 6)	8
Check if "@" exists in an email	=IF(ISNUMBER(SEARCH("@", A1)), "Valid Email", "Invalid Email")