SEARCH ()
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
|
=SEARCH(B2,A2)
|
|
|
3
|
Dear
|
|
2
|
=SEARCH("E",A3)
|
|
|
4
|
Dear
|
a
|
3
|
=SEARCH(B4,A4)
|
|
|
5
|
Albert Parker
|
B
|
3
|
=SEARCH(B5,A5)
|
|
|
6
|
Albert Parker
|
e
|
12
|
=SEARCH(B6,A6,5)
|
|
|
7
|
Albert Parker
|
M
|
#VALUE!
|
=SEARCH(B7,A7)
|
|
|
8
|
01-A20-0020
|
00??
|
8
|
=SEARCH(B8,A8)
|
|
|
9
|
|||||
Unlike FIND, SEARCH function is not case sensitive.
Letters can be written inside function. Like row 3.
#VALUE! will
return as result if no text found.
SEARCH function allows wildcards for custom search. Like row
8.
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
=SEARCH (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.
No comments:
Post a Comment