krkarthik_info

9 years agoFrequent Contributor

# 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 ...

- 9 years ago
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