0

Long formula but it is working for 64-HEX characters:


=HEX2DEC(MID(A24,1,8))*4*2^512+HEX2DEC(MID(A24,9,8))*2*2^512+HEX2DEC(MID(A24,17,8))*2^512+HEX2DEC(MID(A24,25,8))*2^256+HEX2DEC(MID(A24,33,8))*2^128+HEX2DEC(MID(A24,41,8))*2^64+HEX2DEC(MID(A24,49,8))*2^32+HEX2DEC(MID(A24,57,8))


note: all 64 character must be present like the following example:

"0000000000000000000000000000000000000000000000000000000000000fd1"

Cheers