The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If the two strings match, the function returns True. If they do not match, it returns False.

 =EXACT(text1,text2) 

Let’s look at the following example below. The function checks to see if the text value in cell B3 is the same as cell C3. Since they are the same, the result is True.

Exact Function

Leave a Reply

VBA Comment Structure

This section of the VBA learning course reviews the Comment Structure. In every programming language, you need to have the

Read More »

ISOWEEKNUM Function

The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO

Read More »

MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number)

Read More »
Scroll to Top