この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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")結果: 1010
Converts the hexadecimal value A to binary.
=HEX2BIN("F", 8)結果: 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.