Is it possible to write a macro in excel sheet to convert characters to corresponding hex code value.

When the macro is run, all the special characters should get converted to hex code.

By special characters I mean all the characters which are within this range


Latin-1 Supplement (0080-00FF)
Latin Extended-A & B (0100-024F)
General Punctuation (2000-206F)
Currency Symbols (20A0-20CF)
Mathematical Operators (2200-22FF)
Combining Diacritical Marks (0300-036F)

In other words, if a character is encountered in the excel sheet, that has a hex code which falls in any of the above ranges, then it is considered to be a special character and converted to hex code (in the excel sheet).


Thanks