Find Out if Two Cells in Excel Contain Exactly the Same Number
Values  Printer Friendly Text Size: A A A A image description
Like a two-dimensional (or flat) database, Excel is capable of
storing many different types of data from small business
contacts to personal income tax records. In both of these
examples, accuracy is essential to make sure you have the
information you need when you need it.  In any data entry
situation, people often transpose numbers or mistype a name in a
spreadsheet. It is very difficult to tell the difference between
6886 and 6868 or John and Johm when you have long strings of
numbers or text in a busy Excel worksheet.  Using Excel’s built-
in Exact function, you can make Excel do the work for you when
you want to find out whether two cells contain exactly the same
information. The Exact function works equally well for text as
it does for numbers. Continue to read to learn how you can
automate the time-consuming task of checking for accuracy in
your worksheets.  Using Excel’s Exact