Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

EXACT

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

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

Finds position of one text value within another Text in Excel

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

Read More »
Return character position of a text in Excel

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.

Read More »
Count a number of characters in a text string in Excel

LEN

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 »