Skip to Content

SEARCHB

Finds one text string within another (case-insensitive), counting each double-byte character as 2

Syntax

SEARCHB(find_text, within_text, [start_num])

Parameters

  • find_text: Required. The text you want to find
  • within_text: Required. The text in which you want to search
  • start_num: Optional. The byte number at which to start searching (default 1)

Example

=SEARCHB("e", "Statements")
Returns: NumberSince: Excel 2003