Hi,

Identical text will be evaluated as identical but 2 text strings may look
identical but not be and a common cause is rogue spaces which can be got rid
of with

=trim(a1) where A1 is your string.

Mike

"fitou_learn" wrote:

Can someone tell me how to view hidden characters in a cell. Apparently
identical text is not being read as identical.