SEARCH

Finds position of one text value within another Text in Excel
Get part of Text within another Strings (not case sensitive)

Rational

Find the location of one text string within a second text string.

Description

The Excel SEARCH function finds the position of a specified character or sub-string within a text string. The return value depend upon the starting character (start_num) of the text string (within_text). For example, =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.

Syntax

=SEARCH(find_text,within_text,[start_num])

Parameters

find_text – Text to locate
within_text – Text that contains the characters
start_num [Optional] Character number to start searching

Return Value

An integer representing the location of find_text.

Key Notes

  • Unlike the FIND function, SEARCH function is not case sensitive. 
  • If the SEARCH function does not find a match, it will return a #VALUE! error.
  • The default start_num  argument is 1.
  • Return the first character of find text within text.

Keep Reading Similar Functions:

Match two text strings if they are exactly same in Excel

EXACT

The Excel EXACT function display (True or False) after matching two text strings if they are exactly same. Also identifies case-sensitive differences between two text.

Read More »
Count a number of characters in a text string in Excel

LEN

The Excel LEN function counts a number of characters of a given text string excluding number formatting. For example, LEN(“Excel”) returns “5”.

Read More »
To replace part of a text string in Excel

REPLACE

The REPLACE function substitute part of a text string with a new text string. I.e., =REPLACE(“Michael Jackson”,9,6,”Jorda”) returns “Michael Jordan”.

Read More »
Substitutes new text for old text in a text string in Excel

SUBSTITUTE

The SUBSTITUTE function replace the specific text in a text string that occurs in a specific location. i.e, =SUBSTITUTE(“Butter”,”t”,”l”,2) return “Butler”.

Read More »
Return character position of a text in Excel

FIND

The FIND function displays the numerical position of the character in a string. I.e. to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6.

Read More »