Home

Microsoft Excel 2010@

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Comparing Strings

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.

Print this tip.

- Subscribe!

Search the Site: