1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. FIND

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

Back to Top

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"

Back to Top

Similar functions