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


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


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”.




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:

Return character position of a text in Excel


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

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


To replace part of a text string with new substrings based on given position in a selected text.

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


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 »
Substitutes new text for old text in a text string in Excel


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 »
Match two text strings if they are exactly same in Excel


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 »