Excel 2007 : Hex to Binary using a divide and conquer approach for the first and second digit

[miki76]

I am trying to find a formula that convert Hex to Binary. I have already found one but now I am required to use a divide and conquer approach for the first and second digit.
example:
Input Hex B7 (B= 1st digit 7= 2nd digit)
Binary 10110111
someone suggest me to consider Right and Left functions to extract the digits from the input and “&” for concatenating strings… any formula suggestions?

Thanks

[vlady]

say in A1 is B7

=IF(COLUMN(A$1)>LEN($A1),"",MID($A1,COLUMN(A1),1))
drag to the right

learned this from martin.

[miki76]

i tried it and it did not work

[vlady]

this will just get the first and second digit... paste the code above in cell B1 then drag to column C

[vlady]

another way
get letters

Please Login or Register  to view this content.

get numbers

Please Login or Register  to view this content.

[miki76]

I see... yes it works separating the 2 digits... thanks... now i am in the dilemma to find how i use this formula to convert hex to binary and reversal. Do you think you can help.

[vlady]

yes

how about the functions

A1 is hex B7
=hex2bin(A1)
or
A2 is binary number

=bin2hex(A2)
do we require long method as in compute..? or this functions could do...

[miki76]

thank you so much for your help...
I guess this will work... I will continue with the other formulas..

[miki76]

One last question.. is there any option to drag down a column of hex number? so far no luck trying to fine one

[vlady]

i think you can not drag hex numbers to fill they are text..

one work around is to use decimal numbers to fill a column then convert these numbers to hex with dec2hex function, then you can copy paste them.

[miki76]

thank you I have already done that option... you have been very helpful...

[vlady]

your welcome. thanks.