You can read each character by =MID(A1,COLUMNS($1:1),1) [or
=CODE(MID($A1,COLUMN(A1),1)) to see the hidden ones] copied across as many
columns as you need.
--
David Biddulph

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