Hex to Ascii conversion formula in Excel

[Kevalson]

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.

 

[IML]

would
=CHAR(HEX2DEC(A1))
do the trick?

 

[Kevalson]

Yep...

Thanks...