Comparing Fails..

[emukiss10]

Hello,

I need to compare two columns with bank accounts generated by company applicaton and Im stuck.. Searching web does not help : (

The numbers even thou the same - are not.

12 3456 7890 0000 0000 1234 5678 9012 <> 12 3456 7890 0000 0000 1234 5678 9012

To excel both numbers has 32 chars, no broke lines but spaces may not be the same.

replacing copied " " (from number) with normal " " does not work and gives this:

1,23456789000000E+25

(text to columns also does that but mostely it gives normal number)

Changing format, pasting as values - before, after - is not working either.

The numbers are formated as text.

Please help ; (
(ps. I cannot provide any actual account number for security reasons)
W.

 

[arthurbr]

Do they have the same length? Otherwise insert the TRIM function

 

[mole999]

EXCEL IS LIMITED TO 15/16 significant digits, you can compare text strings but not numbers

this works > =IF(TRIM(A1)=TRIM(B1),1,0) treating the values as text

 

[emukiss10]

still, two identical numbers with the same length [=len()] can be shown as 0. I dont know how to match them..