I know you can create a DEC2HEX formula.
I wanted to convert Hex to Ascii.
Example:
=IF(ISBLANK(J15),20,IF(NOT(ISBLANK(J15)),DEC2HEX(CODE(J15))))
When I use HEX2DEC, it puts the ASCII number instead of the actual character.
For instance, if I put the HEX number 4A in Cell A1, I want Cell A2 to display a capital J instead of the number 74 which is J in ASCII.
I wanted to convert Hex to Ascii.
Example:
=IF(ISBLANK(J15),20,IF(NOT(ISBLANK(J15)),DEC2HEX(CODE(J15))))
When I use HEX2DEC, it puts the ASCII number instead of the actual character.
For instance, if I put the HEX number 4A in Cell A1, I want Cell A2 to display a capital J instead of the number 74 which is J in ASCII.