View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
fitou_learn[_2_] fitou_learn[_2_] is offline
external usenet poster
 
Posts: 4
Default 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.