The EXACT function in Microsoft Excel and Google Sheets is a text function used to compare two strings to see if they are a perfect match. It returns TRUE if they are entirely identical and FALSE if there are any differences. Syntax and Arguments
The formula requires exactly two arguments:=EXACT(text1, text2)
text1: The first text string, number, or cell reference you want to compare.
text2: The second text string, number, or cell reference you want to compare. Key Characteristics
Case-Sensitive: Unlike the standard equals operator (=), EXACT distinguishes between uppercase and lowercase letters. For example, =EXACT(“Apple”, “apple”) will evaluate to FALSE.
Ignores Formatting: It ignores differences in visual formatting like bold text, italicized text, or currency symbols. It only compares the raw data values.
Hidden Spaces Matter: If one cell has a trailing or leading space (e.g., “Excel “ vs “Excel”), the function will return FALSE. Common Examples
Leave a Reply