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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can i convert an ASCII character to decimal/hex in Excel? (https://www.excelbanter.com/excel-worksheet-functions/92929-how-can-i-convert-ascii-character-decimal-hex-excel.html)

Surekha

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

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

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

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))

All times are GMT +1. The time now is 08:20 PM.