Note:FIND
Description
FIND searches for a string of text within another text string and returns the character position at which the search string first occurs.
Syntax
FIND ( search_text, text [, start_position] )
|
Parameter |
Description |
|
search_text |
The text to find. If you specify an empty string (" "), FIND matches the first character in text. |
|
Text |
The text to be searched. |
|
start_position |
The character position in text where the search begins. The first character in text is character number 1. When you omit this argument, the default starting position is character number 1. |
Remarks
FIND is case-sensitive. You cannot use wildcard characters in the search_text.
Examples
This function returns 12:
FIND("time", "There's no time like the present")
This function returns 19:
FIND("4", "Aisle 4, Part 123-4-11", 9)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see