Jul 06 2021 06:59 PM - edited Jul 06 2021 07:06 PM
my formula looks just like the example in the Help.
View best response
Jul 06 2021 07:13 PM
Jul 07 2021 02:26 AM
@mountainmanjoe
HEX2BIN function - Office Support (microsoft.com)
As for the Help
Jul 07 2021 10:45 PM
Jul 09 2021 01:04 AM
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
View solution in original post