Whole document tree
    

Whole document tree

SEARCH

SEARCH

Name

SEARCH -- 

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.