Sample usage
SEARCHB("新", "农历新年", 2)
Syntax
SEARCHB(search_for, text_to_search, [starting_at])
search_for– The string to look for within text_to_search.text_to_search– The text to search for the first occurrence of search_for.starting_at– [ OPTIONAL - 1 by default ] – The character position within text_to_search at which to start the search.
Notes
- If
search_foris not found, the #VALUE! error value is returned. - Make sure that
search_forand text_to_search are not supplied in reverse order, or the #VALUE! error will likely be returned. The arguments are supplied in a different order than other text functions such asSPLITandSUBSTITUTE. - It's recommended to use a function such as
IFERRORto check for cases when there aren't matches to the search. - You can use the wildcard characters: question mark (?) and asterisk (*), in
search_for. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character, or seeFINDB. - Use
SEARCHfor standard character sets, and SEARCHB for double-byte character sets such as Japanese, Chinese (Simplified), Chinese (Traditional) and Korean.
See also
SEARCH: Returns the position at which a string is first found within text, ignoring case.
REPLACE: Replaces part of a text string with a different text string.
REGEXREPLACE: Replaces part of a text string with a different text string using regular expressions.
REGEXMATCH: Whether a piece of text matches a regular expression.
SUBSTITUTE: Replaces existing text with new text in a string.
SPLIT: Divides text around a specified character or string and puts each fragment into a separate cell in the row.
FIND: Returns the position at which a string is first found within text, case-sensitive.
FINDB: Returns the position at which a string is first found within text, counting each double character as 2.