How can i convert an ASCII character to decimal/hex in Excel?

Surekha · Jun 8, 2006

Hi,

I would like to convert an ASCII character to Hexadecimal / Decimal in Excel
sheet. Is there any function which can do this for me?

Regards,

MyVeryOwnSelf · Jun 8, 2006

I would like to convert an ASCII character to Hexadecimal / Decimal in

Excel sheet. Is there any function which can do this for me?

ASCII to Decimal:
=CODE(A1)

ASCII to Hexadecimal:
=DEC2HEX(CODE(A1))