SEARCH

Definition of SEARCH:

Returns the position at which a string is first found within text, ignoring case.

Sample Usage

SEARCH("n",A2)

SEARCH("wood","How much wood can a woodchuck chuck",14)

Syntax

SEARCH(search_for, text_to_search, [starting_at])

• search_for - The string to look for within text_to_search.

• text_to_search - The text to search for the first occurrence of search_for.

• starting_at - [ OPTIONAL - 1 by default ] - The character within text_to_search at which to start the search.

Notes

• SEARCH is not case-sensitive, meaning that uppercase and lowercase letters do not matter. For example, "abc" will match "ABC". To compare text where case matters, use the FIND function.
• Ensure that search_for and text_to_search are not supplied in reverse order, or the #VALUE! error will likely be returned. The arguments are supplied in a different order than other text functions such as SPLIT and SUBSTITUTE.
• It's recommended to use a function such as IFERROR to check for cases when there aren't matches to the search.

See Also

SUBSTITUTE: Replaces existing text with new text in a string.

SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

FIND: Returns the position at which a string is first found within text, case-sensitive.

IFERROR: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.

Step 1. To use the SEARCH Formula, start with the Excellentable you would like to edit.

Step 2. Then type the SEARCH formula into the cell you have chosen to display the outcome:

Step 3. Fill in the 2 values.

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14

	E	F
1