# FIND

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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

## Syntax

FIND(*findtext*,*intext*,*start*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *findtext* | 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 |
| *intext* | Text through which you are searching |
| *start* | [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 4

## Version Available

This function is available in product version 1.0 or later.

## See Also

[REPLACE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionREPLACE) \| [SUBSTITUTE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSUBSTITUTE) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)