Excel 2007 : Hex to Binary

[dfoster]

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?

[tigeravatar]

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.

[dfoster]

How would I input the Binary to the yellow cells

[OnErrorGoto0]

=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.

[dfoster]

I don't understand. I formated cells in general.

[OnErrorGoto0]

I am assuming this is the sort of thing you had in mind? (I have only done one binary value)

[dfoster]

I am assuming this is the sort of thing you had in mind? (I have only done one binary value)

Yes something on that order.Thanks!

[kasrarezaie]

I want to convert Hex B000 to Binary.

[Fotis1991]

I want to convert Hex B000 to Binary.

Pls start your own thread as per forum rules.

[kasrarezaie]

i 'm please