**Rational**

Match two text strings if they are exactly alike.

**Description**

The Excel EXACT function display a Boolean result *(True or False)* after matching two text strings if they are exactly same. The EXACT function also identifies case-sensitive differences between two text.

**Syntax**

= EXACT (text1, text2)

**Parameters**

**text1**– The first text string.**text2**– The second text string.

**Return Value**

The boolean result (True or False)

**Key Notes**

- In case of
*both texts*matches, the result will be TRUE, otherwise return FALSE. - The EXACT function will pick case sensitive difference between two strings as well.
- Although the function won’t be able to match the formatting difference.

## Keep Reading Similar Functions:

### SEARCH

The SEARCH function finds the position of a specified character or sub-string within a text string. I.e., =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.

### FIND

The FIND function displays the numerical position of the character in a string. I.e. to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6.

### LEN

The Excel LEN function counts a number of characters of a given text string excluding number formatting. For example, LEN(“Excel”) returns “5”.