View hidden characters
Is it possible to view the rogue spaces?
"Mike H" wrote:
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.
|