The Gnumeric Manual
Prev |  | Next

# SEARCH

## Name

SEARCH --

## Synopsis

    SEARCH(text,within[,start_num])

## Description

SEARCH returns the location of a character or text string within another string. @text is the string or character to be searched. @within is the string in which you want to search. @start_num is the start position of the search in @within. If @start_num is omitted, it is assumed to be one. The search is not case sensitive.

@text can contain wildcard characters (*) and question marks (?) to control the search. A question mark matches with any character and wildcard matches with any string including empty string. If you want the actual wildcard or question mark to be searched, use tilde (~) before the character.

If @text is not found, SEARCH returns #VALUE! error. If @start_num is less than one or it is greater than the length of @within, SEARCH returns #VALUE! error.

This function is Excel compatible.

## Examples

SEARCH("c","Cancel") equals 1.

SEARCH("c","Cancel",2) equals 4.

## See also

FIND.

Prev | Home | Next
RSQ | Up | SECOND