SOLVED

HEX2BIN what am I doing wrong.

Occasional Contributor

my formula looks just like the example in the Help.

 

 

4 Replies
and the help file is actually wrong. FFFFFFFFFF is equal to 1111111111111111111111111111111111111111, not 1111111111
best response confirmed by mountainmanjoe (Occasional Contributor)
well that is a dumb function then

@mountainmanjoe 

If you are on Office 365 you may use something like

=LET(n, A1, k, SEQUENCE(CEILING(LEN(n)/2,1)), CONCAT(HEX2BIN(MID(n, k*2-1, 2))))

as

image.png