+ Reply to Thread
Results 1 to 7 of 7

Convert ASCII characters to Hex values

  1. #1
    Registered User
    Join Date
    06-09-2014
    Location
    Clackamas OR
    MS-Off Ver
    2010
    Posts
    9

    Convert ASCII characters to Hex values

    Is there an easy way to convert ascii characters to their equivalent hex value, such as 0 = 30?
    Thanks,
    Scott
    Last edited by Scott Rebman; 06-09-2014 at 02:05 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Convert ASCII characters to Hex values

    Probably but not being a computer guy, not sure. When you say Ascii characters, are you referring to the code representing each ascii character (i.e. "G" = 71). I thought 0 = 0 whether you are in Dec, binary or Hex? How did you get 0=30?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Convert ASCII characters to Hex values

    I thought 30 in Hex = 48 in dec.?

  4. #4
    Registered User
    Join Date
    06-09-2014
    Location
    Clackamas OR
    MS-Off Ver
    2010
    Posts
    9

    Re: Convert ASCII characters to Hex values

    Quote Originally Posted by ChemistB View Post
    Probably but not being a computer guy, not sure. When you say Ascii characters, are you referring to the code representing each ascii character (i.e. "G" = 71). I thought 0 = 0 whether you are in Dec, binary or Hex? How did you get 0=30?
    Per www.asciitable.com ascii 0 = hex 30 = dec 48.

  5. #5
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Convert ASCII characters to Hex values

    I think you mean:

    =DEC2HEX(CODE(A1))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  6. #6
    Registered User
    Join Date
    06-09-2014
    Location
    Clackamas OR
    MS-Off Ver
    2010
    Posts
    9

    Re: Convert ASCII characters to Hex values

    Exactly what I meant.
    Thanks!

  7. #7
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Convert ASCII characters to Hex values

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help finding all non ASCII characters in spreadsheet
    By MAP-Daniel in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-26-2012, 12:12 PM
  2. ASCII or ANSI characters
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2007, 09:18 PM
  3. Identify certain ASCII characters in a text.
    By titushanke in forum Excel General
    Replies: 6
    Last Post: 02-06-2007, 08:30 AM
  4. [SOLVED] Replacing ascii characters
    By HappyCamper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2006, 03:10 PM
  5. [SOLVED] Arabic characters gives ASCII code 63
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2005, 01:05 PM

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