Converts a hexadecimal number to a binary number.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
HEX2BIN(number, [places])The HEX2BIN function converts a hexadecimal string into its binary equivalent. If the number is negative, the function returns a 10-character two's complement binary number.
=HEX2BIN("A")Result: 1010
Converts the hexadecimal value A to binary.
=HEX2BIN("F", 8)Result: 00001111
Converts F to binary and pads the result to 8 characters.
The number cannot contain more than 10 characters, and the most significant bit is the sign bit.