For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Text Functions

SEARCH Function

Finds one text value within another (not case-sensitive)


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

SEARCH(find_text, within_text, start_num)

  • Managers...
    Charley Kyd can personally help you to apply the Excel methods in this article to your own organization.

    Click here to learn more.
    find_text Required. The text you want to find. You can use the wildcard characters, question mark (?) and asterisk (*) in find_text. A question mark matches any single character and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character. If find_text isn't found, the #VALUE! error is returned.

  • within_text Required. The text in which you want to search for find_text.

  • start_num Optional. The number of the character in within_text counting from the left, at which you want to start searching.

Applies To

Excel 2003 and above

Remarks

SEARCH can use wildcards to search both numbers and text. This is contrast to the SUMIFS function and MATCH function, which can use wildcards only when searching text.

Examples

Examples for Excel's SEARCH function

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards