Summary: Use the =exact function to compare strings inside a Microsoft Excel 2003 spreadsheet.
When developing a Microsoft Excel 2003 spreadsheet, you may need to determine whether two strings match, or whether or not a particular cell matches a text string. To do this, you can use the =exact function to perform a case-sensitive match. The syntax:
=exact(string_or_cell,string_or_cell)
'string_or_cell' can either be a text string delineated by quotes, or a particular cell reference.
For example, if a spreadsheet contains the following cells:
A1: January
B1: February
C1: March
A2: =exact(A1,B1)
B2: =exact("February",B1)
C2: =exact(C1,"March")
D2: =exact("FEBRUARY",B1)
The function results on row 2 would be:
A2: FALSE
B2: TRUE
C2: TRUE
D2: FALSE
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: