B Functions

Functions that end with a "B"
Most of the worksheet functions have been designed for use with languages that use the single-byte character set (SBCS).
None of these functions will appear in the AutoComplete drop-down.
The functions listed here are for use with languages that use the double-byte character set (DBCS).
The languages that support DBCS are: Japanese, Chinese (simplified), Chinese (traditional) and Korean.

FINDB	The position of a substring within a larger text string.
LEFTB	The first or left most characters in a text string.
LENB	The number of characters in a text string.
MIDB	The characters from the middle of a string.
REPLACEB	The text string with a number of characters replaced.
RIGHTB	The last or right most characters in a text string.
SEARCHB	The position of a substring within a larger text string.

FINDB The position of a substring within a larger text string.
LEFTB The first or left most characters in a text string.
LENB The number of characters in a text string.
MIDB The characters from the middle of a string.
REPLACEB The text string with a number of characters replaced.
RIGHTB The last or right most characters in a text string.
SEARCHB The position of a substring within a larger text string.