SEARCH(), SEARCHB()
Syntax
SEARCH(find_text,within_text,start_num)
SEARCHB(find_text,within_text,start_byte)
Definition. The SEARCH() function returns the first occurrence at which a string is found. The search starts at the position indicated by the start_num argument. The function is not case-sensitive.
The SEARCHB() function returns the number of bytes of the characters. This function is used for double-byte strings.
Arguments
find_text (required). The string you are searching for
within_text (required). The text in which to search for find_text
start_num/start_byte (optional). The starting character from which to begin the search
Background. If you edit text, you often need to know the position of a certain character or string within the text—for example, ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
