EXACT

  • Updated

Tests if two strings are identical. Returns TRUE if the strings are identical.

Sample Usage

EXACT("word","WORD")
EXACT(C5,C6)

Syntax

EXACT(text1, text2)

  • text1 - The first string to be checked. 
  • text2 - The second string to be checked. 

Examples

EXACT("word","WORD") returns FALSE. 
EXACT(C5,C6) returns TRUE if the strings in C5 and C6 are identical.

Notes

  • EXACT requires the two strings to have the exact same characters, including identical case and identical spaces or hidden characters.