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
Bookmarks