+ Reply to Thread
Results 1 to 3 of 3

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

Hybrid View

  1. #1
    Surekha
    Guest

    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,

  2. #2
    MyVeryOwnSelf
    Guest

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


  3. #3
    Registered User
    Join Date
    11-17-2022
    Location
    Texas
    MS-Off Ver
    MO 2016
    Posts
    1

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

    The decimal number from 0 to 127 is allocated to each one of those, including letters of the numbers, punctuation marks, and the English alphabet. To manually convert ASCII to decimal, identify the character in the ASCII table, and pick the decimal number against each character in your ASCII string.
    Regards
    Alxender

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1