Export (0) Print
Expand All
Expand Minimize

FIND Function

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Finds one text string contained within another text string, and returns the starting position of the text string you are seeking relative to its position in the text string that contains it.

FIND (find_text, within_text ,[start_num], [ignore_case])

Parameters

Name

Required/Optional

Data Type

Description

find_text

Required

String

The text string you want to find.

format

Required

String

The text string that contains the text you want to find.

start_num

Optional

Number

The character at which to start the search. The first character in within_text is 1. If start_num is missing, it is assumed to be 1.

ignore_case

Optional

Boolean

By default, the FIND function is case-sensitive. If you want the FIND function to ignore case, set this argument to TRUE.

Return Value

Number

If multiple matches are found, the FIND function returns the starting position of the first match in the string. The find_text argument does not consider any characters to be wildcards.

If find_text:

  • Is empty (""), FIND matches the first character in the search string (that is, the character numbered start_num or 1).

  • Does not appear in within_text, FIND returns the #VALUE! error value.

If start_num:

  • Is not greater than zero (0), FIND returns the #VALUE! error value.

  • Is greater than the length of within_text, FINDreturns the #VALUE! error value.

FIND ("2003","January 1, 2003")

Returns 12.

Show:
© 2014 Microsoft