Look for a text string within a text-formatted item, starting at a specified character number (result is a number that denotes the character position). This function is useful for filtering long lists or for deleting items that have specific text somewhere within their name. FIND is case-sensitive, and counts each character as 1, regardless of the default language setting. FIND is supported for use with single-byte character set (SBCS) languages.
Syntax
FIND(x,y,n)
where:
- x: text-formatted cell containing the text to find.
- y: text-formatted cell containing the text to search.
- n: The character number at which to start the search, the first character is 1 (optional).
Format
| Input Format | Output Format |
|---|---|
|
x: Text y: Text n: Number |
Number |
Arguments
The function uses the following arguments:
- x: Text: Text-formatted line item, text constant, or general expression
- y: Text: Text-formatted line item, text constant, or general expression
- n: Number: Numeric line item, property, or expression
Constraints
The function has the following constraints:
- Wild-card and text emoji searches are not supported.
Excel equivalent
Example
FIND("ABC",Customer,4)
The FIND function searches for the text "ABC" within the text-formatted cell Customer, starting at character 4. If it finds the consecutive letters "ABC" anywhere after the fourth character, the result is a number denoting the character position of the start of the text "ABC" within the customer name.
A result of = 0 means no match is found.
FIND("ABC",Customer,4)
- returns 10 where Customer is "Imperial ABC ltd"
FIND("ABC",Customer,4)
- returns 0 where Customer is "Imperial abc ltd"
FIND("ABC",Customer,4)
- returns 0 where Customer is "ABC ltd"
FIND("ABC",Customer,4)
- returns 7 where Customer is "Green ABC Inc"
FIND("ABC",Customer,4)
- returns 0 where Customer is "Green A B C Inc"
FIND("ABC",Customer,4)
- returns 0 where Customer is "Green XYZ Inc"
FIND("ABC",Customer,0)
- returns 1 where Customer is "ABC Green Inc"