+ Reply to Thread
Results 1 to 1 of 1

Convert Hex to Binary formula

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Convert Hex to Binary formula

    I have the following txt data that I would like to convert to binary data. The data source is from ARINC 429 data bus that is monitored/captured via DataTrac RS232 output to computer COM port1. I need to convert the HEX data to 32 bit binary example: data below first line Count=0000 HEX data=3 0 3 1 3 3 9 0.

    bit 32 1
    Desired binary result= 0011 0000 0011 0001 0011 0011 1001 0000

    Count Chan Lbl SDI 32-Hex Data-1 Time Stamp
    00000 1 011 3 30 31 33 90 104837
    00001 1 011 2 A0 41 16 90 105037
    and much more of the same data follows, below is how I can input it into excel with columns space seperated.

    Count Chan Lbl SDI HEX 32-17 HEX 16-1 Time Stamp
    0 1 11 3 30 31 33 90 104837
    1 1 11 2 A0 41 16 90 105037
    2 1 11 0 B5 31 20 90 105237
    3 1 11 2 B2 34 36 90 105437
    4 1 11 2 16 32 32 90 105637
    5 1 11 0 B8 20 44 90 105837
    Last edited by EddieK; 10-02-2012 at 08:41 AM. Reason: detailed desired results

+ 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