CSV compare (excel with multi tabs) highlights matching text after un-matched text

[retesh101]

I am comparing two excel with multi sheet using CSV conversion, excel is converted into csv text. The results come out at as bellow, I am looking for result where 22.0x,26.7x should not be color with red.
can any one advise me please?

,PEE,,,,PRERPSTEST,0.0x,0.0x,0.0x,0.0x,0.0x,0.0x,0.0x,0.0x,0.0x,0.0x, 0.0x,22.0x,26.7x
,PEE,,,,PRERPSTEST,-,-,-,-,-,-,-,-,-,-,-,22.0x,26.7x

[Aaron]

Hello,

Which view are you currently using where these are red? The Text Compare, by default, would align the characters of these lines and mark them as equal. Please double check your current File Format settings, Misc tab, and "Column-based data" is disabled.

The Data Compare should also match those columns, and mark those cells as equal (although the other changes would make the background of that row Red).