EXACT
The EXACT function compares two text strings for exact equality, including letter case. It returns TRUE if the strings are identical and FALSE if they differ.
Syntax 🔗
=EXACT(text1, text2)
text1 | The first text string for comparison. |
text2 | The second text string for comparison. |
About EXACT 🔗
Use the EXACT function in Excel to determine if two text strings are identical, including case sensitivity. This function is useful for tasks like data validation, error checking, or comparing information. EXACT helps you spot any differences between strings, including spaces and special characters, ensuring accurate text comparisons in your dataset.
Examples 🔗
Check if two text strings 'Apple' and 'Apple' are exact matches using the EXACT function. The formula would be: =EXACT("Apple", "Apple")
Verify if 'excel' and 'Excel' are identical using EXACT. The formula would be: =EXACT("excel", "Excel")
Notes 🔗
The EXACT function is case-sensitive, treating uppercase and lowercase letters as distinct. Keep this in mind to avoid discrepancies in your comparisons. EXACT also considers extra spaces or special characters, which may cause differences in similar text strings. Ensure careful text input and formatting for accurate results when using EXACT in your Excel worksheets.
Questions 🔗
If the two text strings are exactly the same, including case sensitivity, the EXACT function returns TRUE.
Does EXACT consider extra spaces or special characters in text comparisons?Yes, EXACT considers extra spaces or special characters in text comparisons. Even a single space or special character difference will result in EXACT returning FALSE for two strings that may appear similar visually.
Is the EXACT function case-sensitive?Yes, the EXACT function is case-sensitive. It differentiates between uppercase and lowercase letters in text comparisons.