Google Sheets-funktion

SEARCH

Returns the position of a text string within another text string, case-insensitive.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

SEARCH(find_text, within_text, [start_num])

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.

Argument

find_textobligatorisktThe text you want to find.
within_textobligatorisktThe text in which you want to search for find_text.
start_numvalfrittThe character number in within_text at which to start the search.

Exempel

=SEARCH("e", "Excel")

Resultat: 1

Finds the first 'e' in 'Excel' starting from the beginning.

=SEARCH("a", "Data", 3)

Resultat: 4

Finds the 'a' in 'Data' starting the search from the 3rd character.

Vanliga frågor

What is the difference between SEARCH and FIND?

SEARCH is case-insensitive and supports wildcards, while FIND is case-sensitive and does not support wildcards.

Relaterade funktioner

FIND MID LEFT RIGHT