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.
No comments:
Post a Comment