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

S

Surekha

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

Excel does not accept text format! 0
Convert Cell Value to ASCII 2
How to count the numbers in a Word document? 0
Numerals conversion 2
Conditional Pagebreaks in Mailmerge 2
Excel is too complicated for me 4
To make pdf to work as word 1
entering special characters 1

Top