Thread: How can i convert an ASCII character to decimal/hex in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf
 
Posts: n/a
Default 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))

Reply With QuoteReply With Quote