[]

Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
  - ARRAYTOTEXT
  - ASC
  - BAHTTEXT
  - CHAR
  - CLEAN
  - CODE
  - CONCAT
  - CONCATENATE
  - DBCS
  - DOLLAR
  - EXACT
  - FIND
  - FINDB
  - FIXED
  - JIS
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LOWER
  - MID
  - MIDB
  - NUMBERVALUE
  - PROPER
  - REPLACE
  - REPLACEB
  - REPT
  - RIGHT
  - RIGHTB
  - SEARCH
  - SEARCHB
  - SUBSTITUTE
  - T
  - TEXT
  - TEXTAFTER
  - TEXTBEFORE
  - TEXTJOIN
  - TEXTSPLIT
  - TRIM
  - UNICHAR
  - UNICODE
  - UPPER
  - VALUE
  - VALUETOTEXT
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

SEARCH

This function finds one text string in another text string and returns the index of the starting position of the found text.

Syntax

SEARCH(findtext, intext, [start])

Arguments

This function has the following arguments:

Argument	Description
findtext	[Required] Refers to the text you are trying to find; if empty (" "), the function matches the first character in the search string (that is, the character numbered start or 1); cannot contain wildcard characters.
intext	[Required] Refers to the text through which you are searching.
start	[Optional] Refers to the number representing character at which to start the search. The first character ofintextargument is 1. If this value is omitted, the calculation starts at 1. If this value is not an integer, the number is truncated.

Examples

SEARCH("e",A2,6)