Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
prs_013
 
Posts: n/a
Default how do I extract hex digits in a cell and convert to binary

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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default how do I extract hex digits in a cell and convert to binary

One way:

A1: AABB

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

Copy B1 down to B4.


In article ,
prs_013 wrote:

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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
prs_013
 
Posts: n/a
Default how do I extract hex digits in a cell and convert to binary

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?

"JE McGimpsey" wrote:

One way:

A1: AABB

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

Copy B1 down to B4.


In article ,
prs_013 wrote:

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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George
 
Posts: n/a
Default how do I extract hex digits in a cell and convert to binary

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

"JE McGimpsey" wrote:


One way:

A1: AABB

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

Copy B1 down to B4.


In article ,
prs_013 wrote:


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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert Number into words in EXCEL same or a new cell ? Rao AM Excel Worksheet Functions 8 February 26th 09 06:56 PM
Converting Dates to 8 digits jermsalerms Excel Worksheet Functions 17 January 20th 06 03:00 AM
how do i convert 100 in one cell to one hundred in another cell Numbers into words Excel Discussion (Misc queries) 1 October 22nd 05 11:35 AM
convert character to value at relative cell Turk Excel Worksheet Functions 2 April 5th 05 10:58 PM
How do I convert cell contents that are Hex to binary? KarenSue33 Excel Worksheet Functions 1 February 21st 05 06:41 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"