EXACT

The EXACT function in Google Sheets is a useful tool to test whether two strings are identical. It can be used to compare text values for exact matches. Learn more about its syntax and usage in our comprehensive guide.

Function Syntax and Parameters

Syntax: EXACT(string1, string2)

Parameters:

• string1: The first string to compare.
• string2: The second string to compare.

Step-by-Step Tutorial

1. Comparing two strings:

   • Example: =EXACT("apple", "apple")
   • Result: TRUE

2. Comparing case-sensitive strings:

   • Example: =EXACT("apple", "Apple")
   • Result: FALSE

3. Comparing the contents of cells:

   • Example: If cell A1 contains the value "apple" and cell B1 contains the value "apple", then =EXACT(A1, B1) will return TRUE.

Use Cases and Scenarios

1. Data Validation: Check if two input strings match.
2. Text Comparison: Determine if two strings have the same content.
3. Formula Verification: Compare the output of two formulas for accuracy.

Related Functions

• LEN: Get the length of a string.
• LOWER: Convert a string to lowercase.
• UPPER: Convert a string to uppercase.
• SUBSTITUTE: Replace text within a string.

Related Articles

• How to Compare Text in Google Sheets Using the EXACT Function
• Mastering Text Functions in Google Sheets