SEARCH

Returns the start position of the find_text string from the first character of the text string.

Syntax

SEARCH(find_text, text, [start_pos])

Arguments

Argument	Description	Required
`find_text`	The text that needs to be found.	Required
`text`	The text in which find_text is to be searched.	Required
`start_pos`	The character number or position in the text argument at which we want to start searching. It should not be 0 or beyond the length of text argument. Defaults to 1.	Optional

Examples

Find text position

=SEARCH("World", "Hello World")

Result ⇒ 7

Search with starting position

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

Result ⇒ 4

Find pattern in cell text

=SEARCH("-", A1)

Result ⇒ 8

	A
1	Product-ABC-123

Related Functions

Other Text functions:

CLEAN - Removes all nonprintable characters from text
CONCATENATE - Returns the concatenation of a list of arguments.
ENDSWITH - Returns TRUE if the text ends with search text, returns FALSE otherwise.
EXACT - Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise
FIND - Returns the position of the first occurrence from within_text.
FIXED - Formats a number as text with a fixed number of decimals
LEFT - Returns a substring from the left side of a supplied string.
LEN - Returns the length of a given string.
LOWER - Returns a string after converting it to lowercase
MID - Returns a substring from the middle of a given string.
PROPER - Capitalizes the first letter in each word of a text value
REGEXMATCH - Returns true if the text matches the regular expression pattern; otherwise returns false.
REPLACE - Replaces part of a text string with a different text string
REPT - Repeats text a given number of times
RIGHT - Returns a substring from the right side of a given string.
STARTSWITH - Returns TRUE if the text starts with search text, returns FALSE otherwise.
SUBSTITUTE - Returns the text after replacing one or more text strings with another text string
TEXTJOIN - Returns the combination of two or more one-dimensional arrays with or without a delimiter.
TRIM - Removes all spaces from a text string except for single spaces between words.
UPPER - Returns the string after converting all letters to uppercase
VALUE - Returns a numeric value for a text that appears in a recognized format (i.e. a number, date, or time format).

← Back to Formula Reference