Finds the first occurrence of:

1) a fragment in the text

2) a value in the array

1) a fragment in the text

2) a value in the array

**Finding a fragment in the text**

Description of formula:

Returns the position of a first character of a sought fragment in a given text. If searched text string appears in text more than once, the

When the fragment does not exist in the text, formula returns 0.

Returns the position of a first character of a sought fragment in a given text. If searched text string appears in text more than once, the

**first**occurrence will be found (to find the last occurrence, use FindLast formula).When the fragment does not exist in the text, formula returns 0.

Syntax:

find(text, fragment, [start])

find(text, fragment, [start])

Parameters:

text

(type: Text) Text in which you want to find given fragment

fragment

(type: Text) Text string that you want to find

start

(type: Number) (optional parameter) Position in the text at which to start the search

Returned type:

Number

Examples:

=find('one two three', 'two')

=find('one two two three', 'two', 6)

=find(A1, B2)

=find('one two three', 'two')

=find('one two two three', 'two', 6)

=find(A1, B2)

Remarks:

Positions of characters in text are numbered from 1. Spaces counts as characters.

The formula is case sensitive.

Positions of characters in text are numbered from 1. Spaces counts as characters.

The formula is case sensitive.

**Finding a value in the array**

Description of formula:

Returns the position of a

The first parameter can be an array of values or cells range. Searched value must have the same type as elements in the array.

Returns the position of a

**first**occurrence of a sought element in a given array (to find the last occurrence, use FindLast formula). If the searched value does not appear in the array, formula returns 0.The first parameter can be an array of values or cells range. Searched value must have the same type as elements in the array.

Syntax:

find(array, element)

find(array, element)

Parameters:

array

(type: array of values of any type) The array in which to find a value

element

(type: any) The value you want to find

Returned type:

Number

Examples:

=find(array('one', 'two', 'three'), 'one')

=find(A1:A12, 'one')

=find(section1.A, 'one')

=find(section1.A, section2.A1)

=find(array('one', 'two', 'three'), 'one')

=find(A1:A12, 'one')

=find(section1.A, 'one')

=find(section1.A, section2.A1)

## 0 Comments