Hex to Ascii conversion formula in Excel

[Kevalson]

I know you can create a DEC2HEX formula.
I wanted to convert Hex to Ascii.

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.

 

[cpod]

=CHAR(HEX2DEC("4A"))

 

[jaybest]

Hey there,

I just thought I would add this - I have 32 bit HEX that I needed to conver to ASCII so just took this a bit further. If you have less than 32 BIT HEX, it will error, just use less of the code:


=CONCATENATE((CHAR(HEX2DEC(MID(A2,1,2)))),(CHAR(HEX2DEC(MID(A2,3,2)))),(CHAR(HEX2DEC(MID(A2,5,2)))),(CHAR(HEX2DEC(MID(A2,7,2)))),(CHAR(HEX2DEC(MID(A2,9,2)))),(CHAR(HEX2DEC(MID(A2,11,2)))),(CHAR(HEX2DEC(MID(A2,13,2)))),(CHAR(HEX2DEC(MID(A2,15,2)))),(CHAR(HEX2DEC(MID(A2,17,2)))),(CHAR(HEX2DEC(MID(A2,19,2)))),(CHAR(HEX2DEC(MID(A2,21,2)))),(CHAR(HEX2DEC(MID(A2,23,2)))),(CHAR(HEX2DEC(MID(A2,25,2)))),(CHAR(HEX2DEC(MID(A2,27,2)))),(CHAR(HEX2DEC(MID(A2,29,2)))),(CHAR(HEX2DEC(MID(A2,31,2)))))

This is for 16 bit data HEX to ASCII

=CONCATENATE((CHAR(HEX2DEC(MID(A2,1,2)))),(CHAR(HEX2DEC(MID(A2,3,2)))),(CHAR(HEX2DEC(MID(A2,5,2)))),(CHAR(HEX2DEC(MID(A2,7,2)))),(CHAR(HEX2DEC(MID(A2,9,2)))),(CHAR(HEX2DEC(MID(A2,11,2)))),(CHAR(HEX2DEC(MID(A2,13,2)))),(CHAR(HEX2DEC(MID(A2,15,2)))))

 

[sirajmodi]

Thanks man,

I need to do reverse in excel - want to convert -- TEXT to HEX

Appreciate your help

Regards,

 

[jaybest]

Does this work? I am in a bit of a rush, but thought that might do it?

=CHAR(DEC2HEX("4A"))

=CONCATENATE((CHAR(DEC2HEX(MID(A2,1,2)))),(CHAR(DEC2HEX(MID(A2,3,2)))),