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

Reply With QuoteReply With Quote