View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Hexadecimal to binary

A very good solution. Once I realized that HEX2BIN was really just playing
with strings, solutions became a lot easier to find.


Have a pleasant weekend
--
Gary's Student


" wrote:

Found it.

=HEX2BIN(LEFT(A3,2),8) & HEX2BIN(RIGHT(A3,2),8)