On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Sunday, May 18, 2014

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.