Convert a hexadecimal number to binary.

`=HEX2BIN(number, [places])`

- number - required, hexadecimal number to convert to binary
- [places] - [OPTIONAL] number of bits in the binary number

`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.

The HEX2BIN function is used to convert a hexadecimal number to binary. It takes a hexadecimal number as an argument and requires more than the minimum number of characters.

- The HEX2BIN function converts a hexadecimal number to its binary equivalent, returning a binary number.

HEX2BIN is a function in programming that converts a hexadecimal number to binary digits.

The binary number is created by using 10 characters.

HEX2BIN requires a hexadecimal number as an argument.

The places argument is optional.

Drop CSV