Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

SEARCH

Description: Returns the number of the character at which a specific character or text string is first found, reading from left to right. SEARCH is not case sensitive and can include wildcard characters.

Syntax: SEARCH(Find_text, Within_text, [Start_num])

Remarks:

Example:

In the following example, SEARCH returns 2 because "" is in the second position within the string.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.