# FIND

## Content

This function finds one text value within another and returns the text value’s position in the text you searched.

## Syntax

`FIND(find_text, within_text, [start_num])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *find\_text* | Text you are trying to find; if empty (" "), the function matches the first character in the search string (that is, the character numbered start or 1); cannot contain wildcard characters |
| *within\_text* | Text through which you are searching |
| *start\_num* | [Optional] Number representing character at which to start the search; the first character of*intext*is 1; if omitted, the calculation starts at 1; if not an integer, the number is truncated |

## Remarks

This function performs a case-specific search (for example, to specify a capital letter and not lower case letters).

## Data Types

Accepts string data for the findtext argument, string data for the intext argument, and numeric data for the start argument. Returns numeric data.

## Examples

`FIND("G",A2,1)`
`FIND("G",R2C1,1)`
`FIND("P","FarPoint Technologies")` gives the result 4
`FIND("n","FarPoint Technologies",8)` gives the result 14