software

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?One way:

A1: AABB

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

Copy B1 down to B4.In article gt;,
prs_013 gt; wrote:

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

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?

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; A1: AABB
gt;
gt; B1: =HEX2BIN(MID($A$1,ROW(),1),4)
gt;
gt; Copy B1 down to B4.
gt;
gt;
gt; In article gt;,
gt; prs_013 gt; wrote:
gt;
gt; gt; I want to evaluea hex expression say AABB and split it to individual cells
gt; gt; in binary
gt; gt; 1010
gt; gt; 1010
gt; gt; 1011
gt; gt; 1011
gt; gt; I can use the HEX2BIN only to convert max of AA. It fails when I try to use
gt; gt; AABB. How do I extract the AA from AABB or extrac A from AA?
gt;

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
prs_013 wrote:
gt; Thanks,
gt; I figured out that I could use the MID function to get what I wanted. I have
gt; a related question. Since I may want to place the values at a different
gt; location, what can I use to replicate the ROW() function to go from 1 to 4
gt; without dependencies on the ROW?
gt;
gt; quot;JE McGimpseyquot; wrote:
gt;
gt;
gt;gt;One way:
gt;gt;
gt;gt;A1: AABB
gt;gt;
gt;gt;B1: =HEX2BIN(MID($A$1,ROW(),1),4)
gt;gt;
gt;gt;Copy B1 down to B4.
gt;gt;
gt;gt;
gt;gt;In article gt;,
gt;gt; prs_013 gt; wrote:
gt;gt;
gt;gt;
gt;gt;gt;I want to evaluea hex expression say AABB and split it to individual cells
gt;gt;gt;in binary
gt;gt;gt;1010
gt;gt;gt;1010
gt;gt;gt;1011
gt;gt;gt;1011
gt;gt;gt;I can use the HEX2BIN only to convert max of AA. It fails when I try to use
gt;gt;gt;AABB. How do I extract the AA from AABB or extrac A from AA?
gt;gt;