Forum Discussion

John Murray's avatar
John Murray
Copper Contributor
Mar 09, 2018
Solved

Data looks to be the same, but EXACT function says it's not - how to I find out why?

I've got two text strings that to the eye appear to be the same.  Even an IF function comparing the two says they are the same.  However, when I use the EXACT function it says they are not.    Th...
Excel EXACT
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 10, 2018

    Hi John,

     

    That's non-printable character between third and fourth zeros in B1. You may remove it manually or SUBSTITUTE if that's repeating in many cells. 

     

    Please see attached.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 10, 2018

John,

 

using LEN() gives you a clue that both values have different length.

Resources