HEX2BIN

Examples

• HEX2BIN(A2, 8)

  The HEX2BIN function can be used to convert hexadecimal numbers to binary. The first argument is the hexadecimal number to be converted, while the second argument is an optional number of places the binary number should be padded to.This example will convert the hexadecimal number in cell A2 to binary, and pad the binary number out to 8 places.

• HEX2BIN(ABCDEFGHIJK, 8)

  HEX2BIN is limited to ten alphanumeric characters. This means it cannot handle hexadecimal numbers with more than ten digits.This example will return an error, as the length of the hexadecimal number is greater than ten characters.

• HEX2BIN(A2, 16)

  The HEX2BIN function will return a binary number that indicates the magnitude of the hexadecimal number. This example will convert the hexadecimal number in cell A2 to binary, and pad the binary number out to 16 places. The first six bits of the binary number will indicate the magnitude of the hexadecimal number.