Match two text strings if they are exactly same in Excel
Match two text strings if they are exactly same


Match two text strings if they are exactly alike.


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.


= EXACT (text1, text2)


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.
Suppose that you have same characters in different cells like here B8 and C8 both have letter F but it return false as C8 contain space. So, EXACT function observe space difference between two text.

Keep Reading Similar Functions:

Count a number of characters in a text string in Excel


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

Read More »
Finds position of one text value within another Text in Excel


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”.

Read More »
Return character position of a text in Excel


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

Read More »