Thread: how do I extract hex digits in a cell and convert to binary
View Single Post
  #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?
Reply With QuoteReply With Quote