FIND

The FIND function is used to locate the position of a substring within a text string. It returns the starting position of the substring within the main text, allowing for easy extraction and manipulation of text data.

Syntax

=FIND(substring, text, [start_num])

substring The text you want to find within the main text.
text The text string in which you want to search for the substring.
start_num (Optional) The character position in the main text where the search should start. If omitted the search starts at the beginning of the text.

About FIND

When you need to pinpoint the exact location of specific text within a larger text block, the FIND function in Excel is your trusted ally. It assists in identifying the position of a substring within a provided text string, facilitating precise text parsing and extraction tasks. Whether you're working with datasets, reports, or any text-heavy content, FIND streamlines the process of locating and extracting crucial information with ease and accuracy. By leveraging this function, you can efficiently navigate through text to uncover valuable insights or manipulate strings for various analytical or formatting purposes.

Examples

Suppose you have the text string 'apple,banana,orange' and you want to find the position of the comma (,) within the text. The FIND formula would be: =FIND(',', 'apple,banana,orange') This will return the position of the comma within the text string.

Consider a scenario where you have the text 'excel is fun' and you wish to find the position of 'is' within the text starting from the 6th character. The FIND formula would be: =FIND('is', 'excel is fun', 6) This will return the position of 'is' starting from the 6th character in the text string.

Questions

How does the FIND function handle case sensitivity?

The FIND function is case-sensitive, meaning it differentiates between uppercase and lowercase letters in the search. Make sure your search criteria matches the case of the text string to accurately locate the desired substring.

What happens if the substring is not found within the text using the FIND function?

If the substring is not found within the text, the FIND function returns a #VALUE! error. Ensure that your search criteria aligns with the text string to avoid this error and accurately locate the specified substring.

Can I use the FIND function to search for multiple instances of a substring within a text string?

Yes, you can utilize the FIND function multiple times to locate different instances of a substring within a text string. By adjusting the starting position parameter, you can sequentially find the positions of various occurrences of the substring in the text.

Related functions

SEARCH
MID
LEFT
RIGHT
SUBSTITUTE