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:
'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:
The function results on row 2 would be:
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: