- Picture and text skills
- Case
FIND is used to find a text string (FIND_text) within another text string (within_text) and returns starting from the first character of within_text
The starting position number of FIND_text. SEARCH can also be used to find a text string in other text strings, but FIND and SEARCH
Different, FIND is case-sensitive and does not allow wildcards.
Syntax
FIND(FIND_text,within_text,start_num)
• Find_text is the text to be found.
• < /span>Within_text is the text containing the text to be found.
• < /span>Start_num specifies the character to start searching for.
Within_text the first character is character number 1. If start_num is omitted, it is assumed to be 1.
Description
• If FIND_text is empty text (), FIND matches the first character in the search string (ie: the character numbered start_num or 1).
• Wildcard characters cannot be included in FIND_text.
• If there is no FIND_text in within_text, return Error value #VALUE!.
• If start_num is not greater than 0, return Error value #VALUE!.
• If start_num is greater than the length of within_text, then Returns the error value #VALUE!.
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-FIND-han-shu-ding-wei-mou-zhi-shou-ci-chu-xian-de-zi-fu-shu.html
评论列表(196条)
测试