EXACTformula compares two strings and returns TRUE if they are identical, including case. It returns FALSE if they are not identical. It is commonly used to check if two cells contain the same text.
- How to use
- Examples of using
EXACTformula not working?
- Similar formulas to
EXACT formula with the syntax shown below, it has 2 required parameters:
- string1 (required):
The first string to compare.
- string2 (required):
The second string to compare.
ExamplesHere are a few example use cases that explain how to use the
EXACTformula in Google Sheets.
Check for exact match
You can use
EXACT to check if two cells contain the same text, including case. This can be useful in data validation or cleaning tasks.
Compare case-sensitive text
EXACT is case-sensitive, so it can be used to compare strings while ignoring case differences. For example, if you want to compare the text 'apple' and 'APPLE' and treat them as different, you can use
Compare text with leading/trailing spaces
EXACT considers leading and trailing spaces when comparing strings. This can be useful to identify differences in text that may not be visible. For example, 'apple' and 'apple ' are considered different by
EXACTnot working? Here are some common mistakes people make when using the
EXACTGoogle Sheets Formula:
Forgetting quotation marks
EXACT formula requires that string values are enclosed in quotation marks. Forgetting to include these can result in a #NAME? error.
Using the wrong data type
EXACT formula only works with text strings. Using it with numbers or other data types can result in unexpected results or errors.
The following functions are similar to
EXACT or are often used with it in a formula:
FINDformula in Google Sheets searches for a specific text within another text and returns the position of the first occurrence of the text. This formula is often used to extract a substring from a larger string or to check if a certain text exists within another text.
SEARCHformula is used to find the position of a piece of text within a larger string of text. It returns the position of the first character of the searched text in the text being searched. This formula is case-insensitive, meaning it will find all instances of the searched text regardless of capitalization.
LOWERformula converts all letters in a specified text string to lowercase. It takes one required parameter, which is the text string to be converted. This formula is commonly used to standardize text data for easier analysis and comparison.
UPPERformula in Google Sheets converts all the letters in a given text string to uppercase. It takes one required argument, the
textto convert. This formula is commonly used to standardize text data or to make it easier to compare text values.
You can learn more about the
EXACT Google Sheets function on Google Support.