Two identical values ​​were taken from two SQL databases. Pay attention to the formula above. There are no spaces anywhere. How is that even possible? Maybe different encoding?

enter image description here

    1 answer 1

    There may be different codes of externally similar characters. Example: c (99, 241), o (111, 238)

    The presence of service characters. Example: characters 10, 32, 160 - if a line break is not set in the cell, all these characters are visible as a space (the real space is 32)

    Check is easy. Insert the formula in the cell and copy down:

    =КОДСИМВ(ПСТР($A$1;СТРОКА(A1);1))=КОДСИМВ(ПСТР($A$2;СТРОКА(A1);1))