Kornilios Ampatzis/ April 19, 2019/ Functions

It compares 2 strings and returns TRUE if they are exactly the same. It is case-sensitive.

The syntax of the function is the following:

EXACT(text1, text2)

text1, text2 : The two text strings to compare.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the EXACT function:

In the cell range C1:C4 use the proper function to return TRUE if the respective cells of the columns A and B are exactly the same.

Share this Post