With the text to search in cell A2, enter =FIND("n",A2) to return the position of the first lowercase n; if A2 contains banana, the result is 3. FIND locates one piece of text inside another and returns its character position, while Ctrl+F opens Excel’s Find dialog to locate content in a worksheet or workbook.
What the FIND function does
FIND is a text function for locating a character or string within a longer text value. Its result is a number, not the matching text itself: a result of 3 means the match begins at the third character. Excel counts positions from 1, so the first character is position 1, the second is position 2, and so on. Spaces and punctuation count as characters too.
This position is useful when another function needs to know where to split or extract text. For example, finding the hyphen in an order code can tell Excel where the order number begins. FIND can also check whether a label or phrase appears in a cell, or help distinguish records based on their contents.
FIND searches text values, including text produced by a formula. It does not change the original cell, highlight a match, or return all matching characters. If your goal is simply to locate and select a value on screen, use the Find dialog instead.
FIND syntax and its arguments
The syntax is FIND(find_text, within_text, [start_num]). The square brackets indicate that start_num is optional; do not type the brackets in a worksheet formula. The arguments mean:
- find_text: The character or text string you want Excel to locate.
- within_text: The text or cell containing the search target.
- start_num: The character position where Excel should begin searching. If omitted, the search starts at position 1.
For example, with the word banana in A2, =FIND("n",A2) returns 3 because the first n is the third character. FIND returns the position at which the requested text begins. If find_text contains more than one character, the result points to the first character of that match.
The start_num argument is a position, not a request for the second or third occurrence. Setting it to 4 means “begin searching at character 4.” It can nevertheless be used to search after an earlier match, as shown below.
Find a character or later occurrence
To locate a particular character in a cell, replace the example search text with the character you need. With an inventory code INV-2048 in A2, =FIND("-",A2) returns 4: I, N, V, and then the hyphen. If the text does not contain the requested character, Excel returns an error instead of a position.
To find the next occurrence of a character, start the second search just after the first match. With banana in A2, =FIND("n",A2,FIND("n",A2)+1) returns 5. The inner FIND locates the first n at position 3; adding 1 makes the outer search start at position 4, where it finds the next n at position 5. If there is no later match, the outer FIND returns an error.
For a specific later occurrence, you can repeat this pattern, but deeply nested formulas become difficult to maintain. If you only need to inspect a few occurrences, separate helper cells can be clearer: put the first position in one cell, then use that result plus 1 as the next search’s start_num. That makes it easier to see which search failed.
FIND is case-sensitive
FIND distinguishes uppercase and lowercase letters. With urgent in A2, =FIND("Urgent",A2) succeeds, but the search will not match if the cell contains only urgent in lowercase. This is useful when capitalization has meaning, but it can cause unexpected errors when text was entered inconsistently.
Use SEARCH when capitalization should not matter. With urgent in A2, =SEARCH("URGENT",A2) returns 1 because SEARCH matches the word regardless of letter case. SEARCH also accepts the wildcard characters ? for one character and * for any number of characters; FIND treats those symbols as literal characters. For a literal tilde in SEARCH, use a doubled tilde to escape it.
Choose based on the question you are asking: use FIND for a case-sensitive literal match, and SEARCH for a case-insensitive match or a pattern using wildcards. Neither function changes the source text, and both return the starting position when a match is found.
Use FIND to extract or check text
FIND becomes especially useful when paired with text functions. Suppose A2 contains Maya Chen and you want the first name, which is the text before the first space. With that layout, =LEFT(A2,FIND(" ",A2)-1) returns Maya. FIND returns 5 for the space, and subtracting 1 tells LEFT to return the first four characters.
For a code such as INV-2048 in A2, the number begins immediately after the hyphen. With that value in A2, =MID(A2,FIND("-",A2)+1,LEN(A2)) returns 2048. FIND identifies the hyphen at position 4; MID starts at position 5 and takes up to the text’s full length. MID returns only the characters available after that starting point.
To test whether text is present without displaying a position, combine FIND with ISNUMBER. If A2 contains a note, =ISNUMBER(FIND("urgent",A2)) returns TRUE when the exact lowercase phrase urgent appears, and FALSE when it does not. Because FIND is case-sensitive, a cell containing Urgent with an uppercase U does not pass this test.
These formulas assume the text has the expected structure. If some names have no space, or some codes have no hyphen, the FIND part can return an error and cause the whole extraction formula to error. Check the data pattern before copying an extraction formula down a long column.
Handle errors when a match is missing
When FIND cannot locate find_text, it returns #VALUE!. The same error can arise if start_num is less than 1 or if it points beyond the available text. A blank search string is a special case and can return the starting position, so avoid passing an empty search value if that is not what you intend.
If a missing match is an ordinary possibility, IFERROR can replace the error with a more useful result. With email-like text in A2, =IFERROR(FIND("@",A2),"Not found") returns the position of @ when present and Not found when it is absent. This formula also catches other errors in the FIND calculation, so use it when treating any such error as “not found” is appropriate.
For data validation or auditing, you may prefer to show an explicit status rather than conceal the error behind a blank. A visible message makes it easier to identify rows that do not follow the expected format. If the result is used in a downstream calculation, make sure the chosen fallback value is suitable for that calculation.
FIND versus Ctrl+F
The FIND function and the Find command solve related but different problems. FIND is part of a formula: it returns a position that can drive an extraction, test, or calculation. Ctrl+F opens the Find dialog, which helps you locate matching cell contents in the interface without building a formula.
In Excel for Microsoft 365 on Windows, press Ctrl+F or choose Home > Find & Select > Find. Type the text in the dialog and choose Find Next to move through matches. The dialog’s options let you adjust where Excel searches, such as the current sheet or the workbook, and what it searches, such as values or formulas. On Mac, Command+F opens the Find interface; dialog details can vary somewhat by Excel version.
Use the dialog if you want to jump to a cell, review occurrences manually, or replace content. Use FIND if the location within each cell matters to a formula. For example, Ctrl+F can help you locate every order code containing a hyphen, but it will not return the hyphen’s character position in a results column.
Common problems and practical checks
If a formula returns #VALUE!, first confirm that the exact text is present and that capitalization matches. Check for extra spaces, punctuation, or a different spelling. A cell that looks like it contains a normal space may contain a nonbreaking space copied from a web page; FIND will not treat that different character as an ordinary space.
Also check the start_num. It must be 1 or greater and should not exceed the length of the text being searched. Remember that an omitted start_num begins at the first character. If your formula searches for a second occurrence, make sure the first match exists before using its position to calculate the next starting point.
When entering formulas, use straight quotation marks around text, balance every parenthesis, and use commas between arguments in standard English-language Excel settings. Some regional settings use semicolons as argument separators, so a formula copied from a comma-based example may need that separator adjustment. The function name remains FIND.
Finally, test formulas against representative rows before filling them down. Include a row with the expected match, one without it, and any unusual formats that appear in your data. This catches errors caused by inconsistent labels and prevents a formula that works on one example from silently being unsuitable for the rest of the column.
Frequently Asked Questions
How do I find a letter in an Excel cell?
With the text in A2, use =FIND("n",A2) to find a lowercase n and return its position. FIND is case-sensitive, so use SEARCH instead if uppercase and lowercase should count as the same.
How do I find the second occurrence of a character?
Use the first occurrence’s position as the basis for the next search. With banana in A2, =FIND("n",A2,FIND("n",A2)+1) returns 5, the position of the second n.
Why does FIND return #VALUE!?
Most often, the requested text is not present exactly as written, including its capitalization, or the start_num is invalid. Check for extra spaces and punctuation, and verify that the search begins at a valid position.
Does FIND support wildcards?
No. FIND searches for literal text, so ? and * are treated as characters to find. SEARCH supports those wildcard characters and does not distinguish uppercase from lowercase.
How do I find a value in the worksheet instead of in a formula?
Press Ctrl+F on Windows or Command+F on Mac to open the Find interface, enter the value, and use Find Next. Use the dialog’s search options to choose the relevant sheet or workbook scope and whether to search values or formulas.
Related
- Excel Tabs: How to Find Duplicate Names Across Sheets
- Excel SUM with Multiple Criteria: How to Do It
- Excel: Subtract the Same Value From Multiple Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert Rows and Columns in Excel: Shortcuts & StepsIn Excel for Microsoft 365 on Windows, select a row with Shift+Space or a column with Ctrl+Space, then…
- Google Sheets IF Function: How It Works and ExamplesIn Google Sheets, use =IF(condition, value_if_true, value_if_false) to return one result when a test is true and another…
- Auto Flash Fill in Excel: How It Works and When to Use ItTo use Flash Fill automatically in Excel for Microsoft 365 on Windows, type an example of the result…
- How Text to Columns Works in ExcelExcel’s Text to Columns tool splits the contents of one column into separate columns, using either characters such…
- Google Docs Monthly Budget Template: Free Ways to StartYes, you can make a monthly budget for free with Google’s tools, but a budget with totals and…
- Find a Circular Reference in Excel and Trace Its SourceTo find a circular reference in Excel for Microsoft 365 on Windows, open the Formulas tab, select Error…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.