:Table text function SEARCHB function finds the location of the specified byte-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Finds a text string (find_text) within another text string (within_text) and returns the starting position number of find_text.

This result is based on the number of bytes used per character, starting at start_num.

This function works with double-byte characters. You can also use FINDB to find text strings within other text strings.

Grammar

SEARCHB(find_text,within_text,start_num)

￭Find_text The text to find. You can use wildcard characters in find_text, including question mark (?) and asterisk (*).

The question mark can match any single character,The asterisk can match any string of characters.

If you want to find a real question mark or asterisk, type a tilde (~) before the character.

￭Within_text The text within which find_text is to be found.

￭Start_num Within_text The number of characters to start searching within.

Description

￭SEARCHB is not case-sensitive when searching text.

￭SEARCHB Similar to FIND and FINDB, but FIND and FINDB are case-sensitive.

￭If find_text is not found, the error value #VALUE! is returned.

￭If start_num is omitted, it is assumed to be 1.

￭If start_num is not greater than 0 (zero) or greater than within_text, the error value #VALUE! is returned.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-SEARCHB-han-shu-cha-zhao-zhi-ding-zi-jie-suo-zai-wei-zhi.html