# How to compare the cell value in excel file?

Hi All,

I am having two excel files with column Formula. Columns having the data like below

Formula in Excel 1 | Formula in Excel 2 |

C₂₁H₂₁O₆ | C21H21O6 |

C₂₂H₂₂O₂F³²S | C22H22O2F[32]S |

On comparing the cell values[C₂₁H₂₁O₆ and C21H21O6], it shows they both are not matched.

Actually they both are same formula.

How to handle this scenario?

Can anyone post your valuable suggestion?

Thanks in advance.

Thanks,

Karthik K R

Hi All,

I have come with a workaround to compare the value character by character, by getting its Unicode character. Figured out the below Unicode characters for digits, subscript digits and superscript digits as below:

For Digits[1-9]:

1 – 49, 2 – 50, 3 – 51, 4 – 52, 5 – 53, 6 – 54, 7 – 55, 8 – 56, 9 – 57

For Subscript Digits[1-9]:

1 – 8321, 2 – 8322, 3 – 8323, 4 – 8324, 5 – 8325, 6 – 8326, 7 – 8327, 8 – 8328, 9 – 8329

For Superscript Digits[1-9]:

1 – 185, 2 – 178, 3 – 179, 4 – 8308, 5 – 8309, 6 – 8310, 7 – 8311, 8 – 8312, 9 – 8313

Thanks all for the suggestions.

Thanks,

Karthik K R