FIND ()
This function finds the text string in a cell or text.
Best view in desktop mode.
|
A
|
B
|
C
|
D
|
E
|
|
|
1
|
Text
|
Letter To Find
|
Position Of Letter
|
||
|
2
|
Dear
|
r
|
4
|
=FIND(B2,A2)
|
|
|
3
|
Dear
|
2
|
=FIND(“e”,A3)
|
||
|
4
|
Dear
|
a
|
3
|
=FIND(B4,A4)
|
|
|
5
|
Albert Parker
|
B
|
#VALUE!
|
=FIND(B5,A5)
|
|
|
6
|
Albert Parker
|
e
|
12
|
=FIND(B6,A6,5)
|
|
|
7
|
Albert Parker
|
M
|
#VALUE!
|
=FIND(B7,A7)
|
|
|
8
|
|||||
This function is case sensitive.
Letters can be written inside function. Like row 3.
#VALUE! will
return as result if no text found.
If a text string available multiple times in a cell then we
can give a position in the function. And function will find the text string
after that number position. Like row 6.
Syntax
=FIND (find_text,
within_text, [start_num])
Where
find_text =
text to find in the string.
within_text = text
to search within.
[start_num] = starting
position in the text to search. [optional]
Formatting
No special
formatting is needed.
Dear sir, please extract the specific string from this text .
ReplyDeleteexample=
RUSK987 987 FAS 776 -697 EMP ID-F 9875 ROBIN CHU.eng
I have need after ID - "F 9875” and “ROBIN CHU” in different cell .