:Table text function SEARCH function finds the first occurrence of a character-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

SEARCH returns the number of a specific character at the position starting from start_num where the specific character or text string is first found.

Use SEARCH to determine the position of a character or text string within another text string so that you can use the MID or REPLACE function to change the text.

Syntax
SEARCH(find_text,within_text,start_num)
Find_text is the text to be found. Wildcard characters can be used in find_text, including question mark (?) and asterisk (*), which 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 is the text in which find_text is to be found .
Start_num is the character to start searching within_text serial number.

Description
• SEARCH is not case-sensitive when searching for text.
• SEARCH is similar to FIND, but FIND is different Upper and lower case.
• If find_text is not found, an error is returned Value #VALUE!.
• 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.

SEARCH function is a The search function returns the first occurrence of a specified character or text string in the string.
Give an example to help everyone understand this function.

￭ Suppose we want to find the position where the word "No" first appears in cell (A2).
First select the cell (A5), click Insert function, find the SEARCH function, and click OK.

￭ Here, we need to fill in three values and enter "No" in the search string. Because we are searching in cell (A2), the string being searched
Fill in (A2). The starting position refers to the character from which we start searching. If not filled in, the default is 1.
Assume we start searching from the first character, you can see that the result shows that the first occurrence of "No" is in (A2) 2nd position.

￭ Suppose we start searching from the 3rd character, change the starting character to 3, click OK, we find that the result displays "4".

This is because the scope of our search changes to after the third character of "Do you know? It should be green, fat, red and thin", so the search The first occurrence of "No" is reached
The position becomes the 4th position in the text. This function is a basic function and is often used in combination with other functions. You must learn it~

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-SEARCH-han-shu-cha-zhao-zi-fu-shou-ci-chu-xian-wei-zhi.html