Hex to Ascii conversion formula in Excel

Kevalson · Apr 17th, 2002, 11:52 AM

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 · Apr 17th, 2002, 11:59 AM

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

Kevalson · Apr 17th, 2002, 12:07 PM

Yep...

Thanks...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 11:52 AM	#1
Kevalson New Member Join Date: Apr 2002 Posts: 11	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.

Apr 17th, 2002, 11:59 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	would =CHAR(HEX2DEC(A1)) do the trick?

Apr 17th, 2002, 12:07 PM	#3
Kevalson New Member Join Date: Apr 2002 Posts: 11	Yep... Thanks...