View hidden characters

F

fitou_learn

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

Mike H

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
 
F

fitou_learn

Is it possible to view the rogue spaces?

Mike H said:
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
Click to expand...
 
M

Mike H

Hi,

Seeing a space at the end/start of a word would be an imposing challenge.
You can test for them being there with

=LEN(a1)

will return the number of characters in the cell including leading/trailling
spaces.

Mike
 
D

David Biddulph

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.
 
Top