FIND function in MS-Excel

	C	D	E
3	Text	Letter To Find	Position Of Letter
4	Hello	e	2	=FIND(D4,C4)
5	Hello	H	1	=FIND(D5,C5)
6	Hello	o	5	=FIND(D6,C6)
7	Alan Williams	a	3	=FIND(D7,C7)
8	Alan Williams	a	11	=FIND(D8,C8,6)
9	Alan Williams	T	#VALUE!	=FIND(D9,C9)

What Does It Do?

This function looks for a specified letter inside another piece of text.

When the letter is found the position is shown as a number.

If the text contains more than one reference to the letter, the first occurrence is used.

An additional option can be used to start the search at a specific point in the text, thus enabling the search to find duplicate occurrences of the letter.

If the letter is not found in the text, the result #VALUE is shown.

Syntax                                                                 

=FIND(LetterToLookFor,TextToLookInside,StartPosition)                                                                       

LetterToLookFor : This needs to be a single character.

TextToLookInside : This is the piece of text to be searched through                                                             

StartPosition : This is optional, it specifies at which point in the text the search should begin.