I want to convert Hex to Binary. I want the Binary in 8 different cells.
The hex input would be lets say A1 I would want to convert that
to eight different cells Bit7 G10, Bit6 G12, Bit5 G14, Bit4 G16, Bit3 E10, Bit2 E12, Bit1 E14 and Bit0 E16.
Then I want another Hex input on A2 and convert that to eight diferent cells.
Bit7 K10, Bit6 K12, Bit5 K14, Bit4 K16, Bit3 I10, Bit2 I12, Bit1 I14 and Bit0 I16.
How would I do This?
dfoster,
Attached is an example workbook based on the criteria you described. The contents of rows 7 and 8 are optional, and just used to easily show what the hex and its corresponding bin is.
Last edited by tigeravatar; 02-07-2012 at 03:42 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
How would I input the Binary to the yellow cells
=LEFT(F7,1)
to get the leftmost bit
=MID(F7,2,1)
to get the second bit and so on. You will need to format the yellow cells as General rather than text in order to enter the formulas, though.
Good luck.
I don't understand. I formated cells in general.
I am assuming this is the sort of thing you had in mind? (I have only done one binary value)
Good luck.
Yes something on that order.Thanks!Originally Posted by OnErrorGoto0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks