how do I extract hex digits in a cell and convert to binary

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prs_013 - 15 Mar 2006 17:42 GMT

I want to evaluea hex expression say AABB and split it to individual cells
in binary
1010
1010
1011
1011
I can use the HEX2BIN only to convert max of AA. It fails when I try to use
AABB. How do I extract the AA from AABB or extrac A from AA?

Reply to this Message

JE McGimpsey - 15 Mar 2006 18:21 GMT

One way:

A1: AABB

B1: =HEX2BIN(MID($A$1,ROW(),1),4)

Copy B1 down to B4.

> I want to evaluea hex expression say AABB and split it to individual cells
> in binary
[quoted text clipped - 4 lines]
> I can use the HEX2BIN only to convert max of AA. It fails when I try to use
> AABB. How do I extract the AA from AABB or extrac A from AA?

Reply to this Message

prs_013 - 16 Mar 2006 18:38 GMT

Thanks,
I figured out that I could use the MID function to get what I wanted. I have
a related question. Since I may want to place the values at a different
location, what can I use to replicate the ROW() function to go from 1 to 4
without dependencies on the ROW?

> One way:
>
[quoted text clipped - 12 lines]
> > I can use the HEX2BIN only to convert max of AA. It fails when I try to use
> > AABB. How do I extract the AA from AABB or extrac A from AA?

Reply to this Message

George - 17 Mar 2006 08:14 GMT

The row() basically returns 1 to 4 so that it may extract each character
1 at a time.
Some options are;
You can manually enter the values 1 to 4 instead of Row()
if you moved the answers down to row 10
You could use Row()-9
If you moved the answers into columns say Column G (= column 7)
You could use Column()-6

One other method would be to copy the numbers 1 to 4 in an adjacent
column to where you want the answers, and then just refer to that cell
instead.

Hope I sent you on the right path
George

> Thanks,
> I figured out that I could use the MID function to get what I wanted. I have
[quoted text clipped - 18 lines]
>>>I can use the HEX2BIN only to convert max of AA. It fails when I try to use
>>>AABB. How do I extract the AA from AABB or extrac A from AA?

Reply to this Message