FIND function

 

Use the FIND function in Excel to find the position of a substring in a string. The FIND function is case-sensitive.

1. The FIND function below finds the string “ro” at position 4.

Find Function in Excel

2. The FIND function below finds the string “Excel” at position 11.

Find Case-sensitive Text

3. The FIND function is case-sensitive. The FIND function below returns the #VALUE! error because it cannot find the string “excel”.

Find Function is Case-sensitive

The FIND function has a 3rd optional argument. You can use this argument to indicate the position, counting from the left, at which you want to start searching.

4. The FIND function below finds the string “o” at position 5.

Start Searching at Position 1

5. The FIND function below starts searching at position 6 and finds the string “o” at position 7.

Start Searching at Position 6

Note: the SEARCH function in Excel is case-insensitive and supports wildcards.

Previous articleCreate Drop-down Lists in Excel
Next articleGoal Seek in Excel