Find Formula
|
|
Text
|
Letter To Find
|
Position Of Letter
|
|
|
|
Hello
|
e
|
2
|
=FIND(D4,C4)
|
|
|
Hello
|
H
|
1
|
=FIND(D5,C5)
|
|
|
Hello
|
o
|
5
|
=FIND(D6,C6)
|
|
|
Alan Williams
|
a
|
3
|
=FIND(D7,C7)
|
|
|
Alan Williams
|
a
|
11
|
=FIND(D8,C8,6)
|
|
|
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.
|
||||
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
No
special formatting is needed, the result will be shown as a number.
|
||||