Find

Finds the first occurrence of:
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 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])
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)
Remarks:
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 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)
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)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk