This article describes the formula syntax and usage of the EXACT
function (function: A prewritten formula that takes a value or
values, performs an operation, and returns a value or values.
Use functions to simplify and shorten formulas on a worksheet,
especially those that perform lengthy or complex calculations.)
in Microsoft Excel. Compares two text strings and returns TRUE
if they are exactly the same, FALSE otherwise. EXACT is case-
sensitive but ignores formatting differences. Use EXACT to test
text being entered into a document. The EXACT function syntax
has the following arguments (argument: A value that provides
information to an action, an event, a method, a property, a
function, or a procedure.): - Text1 Required. The first text
string. - Text2 Required. The second text string. The example
may be easier to understand if you copy it to a blank worksheet.
How do I copy an example? - Select the example in this article.
If you are copying the example in Excel Web App, copy and paste
one cell at a time.I