Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

FIND Operation

How to use the FIND operation in formulas

Definition

Example

Syntax Guide

 

Definition

The FIND operation finds the first position of a string found in a text and is case sensitive. 

 

Example

FIND("e","Hello There!")

Result:
2

 

ℹ️ If the formula doesn't find any instances, the result is NULL. 

 

Syntax Guide

FIND(search_for, text_to_search, [starting_at])

search_for - The string to look for within text_to_search

text_to_search - The text to search for the first occurrence of search_for

starting_at (OPTIONAL) - The character within text_to_search at which to start the search. If left blank the system will use 1 by default )

 

What's Next?