FINDB function
FINDB returns the byte position where one piece of text first appears inside another, counting each double-byte character as two. It matches FIND unless an East Asian language is enabled.
Example
A
B
C
D
1
3
2
3
Syntax
FINDB(find_text, within_text, [start_num])
Arguments in [square brackets] are optional.
-
find_text(required) - The text to look for.
-
within_text(required) - The text to search in.
-
start_num(optional) - Byte position to begin from; default 1.
Returns: The byte position of the first match.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FINDB("b","abc") | 2 | Single-byte text |
=FINDB("c","日本c") | 3 | After double-byte characters |
Watch out for
- Same results as FIND in non-double-byte settings.
- Case-sensitive.
Where it works
- Excel
- FINDB is in every version of Excel from 2007 on. Differs from the non-B version only in East Asian (double-byte) language settings.
- Google Sheets
- No direct equivalent. Use FIND.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .