Use Of FIND
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, start position)
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.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें