Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

FINDB

Description: Finds one text string within another text string, and returns the number of the starting position of Find_text, from the leftmost character of Within_text. FINDB is case sensitive and cannot include wildcard characters. This function is for use with double-byte characters.

• FINDB is intended for use with languages that use the double-byte character set (DBCS). FINDB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, FINDB counts each character as 1.

Syntax: FINDB(Find_text, Within_text, [Start_num])

• Find_text is the text you want to find.

• Within_text is the text containing the text you want to find.

• Start_num specifies the character at which to start the search. The first character in Within_text is character number 1. If you omit Start_num, it is assumed to be 1.

Remarks:

• FINDB is case sensitive and doesn't allow wildcard characters. If you don't want to do a case sensitive search or use wildcard characters, you can use the SEARCHB function.

• If Find_text does not appear in Within_text, FINDB returns the #VALUE! error value.

• Start_num must be greater than 0.

• Start_num must be less than or equal to the length of Within_text.

Example:

In the following example, FINDB returns 3 because each character is counted by its bytes; the first character has 2 bytes, so the second character begins at byte 3.

• FINDB("", "") = 3