Use chunking to convert large hex values one hexal at a time:

Let's say we have 1abc in A1. HEX2BIN() won't work. In A2 thru A5 put:

=HEX2BIN(LEFT(A1))
=HEX2BIN(MID(A1,2,1))
=HEX2BIN(MID(A1,3,1))
=HEX2BIN(RIGHT(A1))
and you will see:

1
1010
1011
1100

in A6 put:
=A2&A3&A4&A5
to see:
1101010111100
all 13 bits
You can now concatenate enough leading zeros to make any fixed length.


--
Gary''s Student


" wrote:

Can someone point me to an online resource or explain how I can convert a
hexadecimal number into a binary number whilst also retaining the leading
zeros.
Some of the hex numbers are too large for the HEX2BIN function. I need the
leading zeros in the result so I can look at specific chunks bit values
using MID().

Tia