EXACT Function

The EXACT function is used to find if the given two texts are exactly the same, by comparing with each other. The function returns TRUE if both the texts are same and returns FALSE if they do not match.
Note: This function considers the position of letters, upper/lower case and the spelling. Also this can compare only two texts.

Formula:


=EXACT (text 1, text 2)

Video Tutorial:


Let us find if the given texts are same, using the EXACT function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question