deepcalc
DocsFINDB

FINDB

View as markdown/docs/functions/findb.md Ask Claude about this pageOpens Claude with this page's address

Finds text within text by bytes, case-sensitive.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=FINDB("M", "Miriam McGovern")
Result 1

Syntax

FINDB(find_text, within_text, [start_num])
find_text
text required
within_text
text required
start_num
number optional defaults to 1
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.