Returns the position of a text string within another text string, case-insensitive.
Składnia
SEARCH(find_text, within_text, [start_num])Argumenty
find_textwymagane
The text you want to find.
within_textwymagane
The text in which you want to search for find_text.
start_numopcjonalne
The character number in within_text at which to start the search.
The SEARCH function locates one text string within another and returns the starting position of the first character. It is case-insensitive and supports wildcard characters like the asterisk and question mark.
=SEARCH("e", "Excel")→1Finds the first 'e' in 'Excel' starting from the beginning.
=SEARCH("a", "Data", 3)→4Finds the 'a' in 'Data' starting the search from the 3rd character.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =SEARCH(find_text, within_text) and replace the arguments with your specific text or cell references.
SEARCH is case-insensitive and supports wildcards, while FIND is case-sensitive and does not support wildcards.