Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Searching for Strings (FIND – Case-Sensitive)

Syntax: FIND(Find_Text; Source_Text; Start_From)

This function finds the starting position of the specified text string (find_text) within another text string (source_text). For example:

=FIND("Office"; "OpenOffice.org")

returns 5, the starting position of the Office string within the OpenOffice.org string.

Figure 10-4. Sample result of the FIND function

The third, optional argument start_from is used to specify the starting position within source_text from which FIND begins looking for the find_text string.