HEX2BIN what am I doing wrong.

[mountainmanjoe]

my formula looks just like the example in the Help.

[#2]

and the help file is actually wrong. FFFFFFFFFF is equal to 1111111111111111111111111111111111111111, not 1111111111

[#3 · Accepted solution]

@mountainmanjoe 

HEX2BIN function - Office Support (microsoft.com)

As for the Help

[#4]

well that is a dumb function then

[#5]

@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