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

G

Guest

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,
 
M

MyVeryOwnSelf

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

ASCII to Decimal:
=CODE(A1)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Convert Cell Value to ASCII 1
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 2
How to convert decimal year to date format in excel 2
Convert a file to an ASCII 1
Convert Ascii string to decimal 8
Numerals conversion 2
Missing function in Excel 3

Top