Finds one text value within another (not case-sensitive)
Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports
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.
|Charley Kyd can
personally help you to apply the Excel methods in this
article to your own organization.
Click here to learn more.
Required. The text in which you want to search for
Optional. The number of the character in within_text
counting from the left, at which you want to start
Excel 2003 and above
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.