Overview
Grammar | EXACT(text1,text2) | Determines whether two text strings are identical. If they are exactly the same, EXACT returns TRUE; otherwise, returns FALSE. |
Parameter 1 | Text1 | First text string to be compared |
Parameter 2 | Text2 | Second text string to be compared |
Notes
The EXACT function is case-sensitive but format-insensitive. It can also be used to test the text entered into a document.
The function supports two parameters of any type.
Example
| Formula | Result | Notes |
|---|---|---|
| EXACT("Spreadsheet","Spreadsheet") | TRUE | |
| EXACT("Spreadsheet","S preadsheet") | FALSE | |
| EXACT("Spreadsheet","spreadsheet") | FALSE |
