Excel 2007 : Hexadecimal to Binary conversions

I want to be able to input HEX for example on Cell A1 FF and have it converted to binary in eight different cells D1,E1,F1,G1,H1,I1,J1,K1 FOR BITS 7,6,5,4,3,2,1,0 CAN THIS BE DONE?

Originally Posted by MarvinP

Hi dfoster and welcome to the forum.

Excel has a function called Hex2Bin that should do your problem.
http://office.microsoft.com/en-us/ex...005209110.aspx or
http://www.excelfunctions.net/Excel-...-Function.html

Yes that works no problem but it puts the binary into one cell I want the binary to go to eight different cells.

In D1 put the formula:

=MID(TEXT(HEX2BIN($A1),"00000000"),COLUMN()-3,1)

And copy it across to K1.

That did the trick Thank You!!!

What if I wanted the Binary in 8 cells K10,k12,k14,k16,i10,i12,i14,i16 b7-b0 or
j10,j12,j14,j16,e10,e12,e14,16 b7-bo?

In my formula the bit in bold is determining which digit appears in which cell...

=MID(TEXT(HEX2BIN($A1),"00000000"),COLUMN()-3,1)

So it would be a case of playing with that, so for the first cell in your range has a value in there that resolves to 1, the 2nd has a value that resolves to 2, etc.

To place in columns 10, 12, 14... you'd want something like:

=MID(TEXT(HEX2BIN($A1),"00000000"),(COLUMN()-8)/2,1)