Skip to content
Astera Technology

Compare Calc review labels with case and spaces intact

Check complete strings without treating similar-looking labels as equivalent.

Download complete case notes and answer keys ↓

Work with the example

Are these proof labels exactly the same as their originals? C uses EXACT(A5;B5); D describes the result. B6 has a trailing space after Room 2. A7/B7 are the same supplied Chinese label.

Supplied exercise data
OriginalReviewEXACT
RevArevaFALSE
Room 2Room 2 + trailing spaceFALSE
原稿原稿TRUE

Edit the working cells

Change B5 to RevA: C5 becomesTRUE. A fresh B7="原稿 " givesFALSE because of the added space. Read the complete strings in the formula bar where an ending space may be hard to see.

Check the failure case

The ordinary comparison =A5=B5 returnsTRUE for baseline RevA/reva in Calc, while EXACT returnsFALSE. Neither equality test establishes identity, approval or translation meaning.

Does FALSE prove that the review text is wrong?

Show the worked answer

No. It proves a string difference; a person still decides whether the intended wording changed.

Example files

Related resources