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

"fitou_learn" wrote:

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.