Example of using the find function in excel

Use syntax

FIND (find_text, within_text, start_num)
Find_text is the string to be searched.
Within_text is the cell that contains the keyword to be searched. That is to say, you need to search for keywords in this cell.
Start_num specifies the number of characters to start searching. For example, if Start_num is 1, the keyword is searched from the first character in the cell. If start_num is ignored, 1 is assumed.

Note:

You can use start_num to skip a specified number of characters. For example, assume that the text string "AYF0093.YoungMensApparel" is used. If you want to find the first "Y" number in the description section of the text string, you can set start_num to 8, in this way, the serial number of the text will not be searched. FIND will start from 8th characters, and find_text will be found in the next character, so return number 9. FIND always returns the character number from the beginning of within_text. If start_num is greater than 1, it also counts the skipped characters.
If find_text is null text (), FIND returns the value 1.
Find_text cannot contain wildcards.
If no find_text exists in within_text, FIND returns the error VALUE # VALUE !.
If start_num is not greater than 0, FIND returns an error VALUE # VALUE !.
If start_num is longer than within_text, FIND returns the error VALUE # VALUE !.

Application example

Find formula expression

Find (find_text, within_text, start_num), where find_text refers to "search target", within_text refers to "target cell", and start_num refers to "start position ".

Enter an equal sign in excel, that is, "=". Generally, no matter what formula is, enter an equal sign in the first step, and enter find. As shown in the following figure:

Enter the target to be searched. This can be a symbol, an English letter, or a number. However, make sure that there is only one such target in a table. Otherwise, the first position is found by default.

Enter "comma" after the previous step to continue the next step. Enter the target cell, and enter "comma" later ".

The function of the last item is to let us determine from the first few characters. Generally, it is "1", and the last step is omitted. The default value is "1". Then click "OK" to get the answer.

Usually used with the left function

When the second parameter in left is not fixed, the find function can be used to determine the position, which can help us save a lot of time.

Notes

The last parameter of find must be less than 1.

The target of the find function is generally unique. If it is not unique, it must be determined as a unique value. Otherwise, a result error will occur.