LibO 4.2.6.2 Calc / XP

I need to compare a longer list of text being located in 2 colums on a row by row level To see quickly which rows have different values in both columns I used the EXACT function which, according the Help file, “Compares two text strings and returns TRUE if they are identical. This function is case-sensitive.”

Colum B contains the EXACT function

Column C and D contain in each row the text I need to compare

Example

B3: Formula: =EXACT(C3,D3) Result: TRUE

C3: “Date submitted” (without quotation marks)

D3: “Completed” (without quotation marks)

What am I doing wrong?

Thanks for your help in advance.