G
Guest
Can someone tell me how to view hidden characters in a cell. Apparently
identical text is not being read as identical.
identical text is not being read as identical.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
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
G
Guest
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
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.
=CODE(MID($A1,COLUMN(A1),1)) to see the hidden ones] copied across as many
columns as you need.
D
Dave Peterson
Chip Pearson has a very nice addin that will help determine what those
characters are:
http://www.cpearson.com/excel/CellView.htm
characters are:
http://www.cpearson.com/excel/CellView.htm