Functions
SEARCHB
Case-insensitive byte-position search with wildcards
Try it
When to use it
When should I use SEARCHB instead of SEARCH?
Use SEARCHB when you need a case-insensitive byte-position search with wildcard support for text that may contain multibyte characters.
Used in
Syntax
SEARCHB(find_text, within_text, [start_num])Examples
=SEARCHB("新","农历新年") // => 5
=SEARCHB("新","农历新年",2) // => 5
=SEARCHB("n","printing") // => 4