Exceljet

Quick, clean, and to the point

Excel SEARCH Function

Excel SEARCH function
Summary 
The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of the first character of find_text inside within_text. Unlike FIND, SEARCH allows wildcards, and is not case-sensitive.
Purpose 
Get the location of text in a string
Return value 
A number representing the location of find_text.
Syntax 
=SEARCH (find_text, within_text, [start_num])
Arguments 
  • find_text - The text to find.
  • within_text - The text to search within.
  • start_num - [optional] Starting position in the text to search. Optional, defaults to 1.
Usage notes 

Use the SEARCH function to get the location of one text string inside another.

  • SEARCH returns the position of the first character of find_text inside within_text.
  • Unlike FIND, SEARCH allows the use of wildcards, and is not case-sensitive.
  • SEARCH allows the wildcard characters question mark (?) and asterisk (*), in find_text.
  • The ? matches any single character and the * matches any sequence of characters.
  • To find a literal ? or *, use a tilde (~) before the character, i.e. ~* and ~?.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables