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:
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Comparing Strings.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.