Excel
EXACT function in Excel
Checks to see if two text values are identical
=EXACT(text1, text2)EXACT syntax and parameters
Two arguments, two required.
- text1stringRequired
The first text string.
- text2stringRequired
The second text string.
EXACT examples
Formulas you'll actually reuse.
A case-sensitive comparison — “Lopez” vs “lopez” is FALSE:
=EXACT(A2, B2)Result
FALSEA case-sensitive count of a code (COUNTIF ignores case):
=SUMPRODUCT(--EXACT(A2:A200, "ABC-1"))Result
3
EXACT in Google Sheets
Same name — your formula ports as-is.
Try EXACT in the playground
Edit the example — nothing to install.
Preloaded with the EXACT formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets