Return character position of a text in Excel
Return character position in a text.


Find the letter’s position in a text.


The Excel FIND function displays the numerical location of the character in a given text. The starting position of a String can change based on the third argument [Start_num].

For example, to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6, start finding 8 from 4th digit that returns 6, i.e., 6th position in the figure.


= FIND(find_text, within_text, [start_num])


find_text – The character to find
within_text – The string containing the character
start_num [Optional] – Specifies the character to start the search.

Return Value

The boolean result (True or False)

Key Notes

  • In FIND function, the first character in the within_text argument is character number 1 (default position).
  • The FIND function is case sensitive and does not allow wildcard characters.
  • Use the SEARCH excel function if a user wants to perform a non-case-sensitive search and enable wildcard characters.

The FIND function returns the #VALUE! error value in case

  1. start_num is not greater than zero
  2. start_num is greater than the length of within_text
  3. find_text does not appear in within_text

Note: start_num [Optional] is important to return the position based on occurrence of the character. 

Keep Reading Similar Functions:

Match two text strings if they are exactly same in Excel


The Excel EXACT function display (True or False) after matching two text strings if they are exactly same. Also identifies case-sensitive differences between two text.

Read More »
Finds position of one text value within another Text in Excel


The SEARCH function finds the position of a specified character or sub-string within a text string. I.e., =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.

Read More »
Count a number of characters in a text string in Excel


The Excel LEN function counts a number of characters of a given text string excluding number formatting. For example, LEN(“Excel”) returns “5”.

Read More »