Formulas and Functions

EXACT
The EXACT function returns TRUE if the argument strings are identical in case and
content.
EXACT(string-1, string-2)
 string-1: The rst string. string-1 is a string value.
 string-2: The second string. string-2 is a string value.
Examples
=EXACT(”toledo”, “toledo”) returns TRUE, since all the characters and their cases are identical.
=EXACT(”Toledo”, “toledo”) returns FALSE, since the case of the two strings is not identical.
Related Topics
For related functions and additional information, see:
“FIND” on page 312
“SEARCH” on page 320
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
FIND
The FIND function returns the starting position of one string within another.
FIND(search-string, source-string, start-pos)
 search-string: The string to nd. search-string is a string value.
 source-string: A string. source-string is a string value.
 start-pos: An optional argument that species the position within the specied
string at which the action should begin. start-pos is a number value that must be
greater than or equal to 1 and less than or equal to the number of characters in
source-string.
Notes
The search is case sensitive and spaces are counted. Wildcards are not allowed. To Â
use wildcards or to ignore case in your search, use the SEARCH function.
312 Chapter 11 Text Functions