BIN2HEX
Since binary represents 0 and 1 sometimes user may require to perform Binary to Hexadecimal conversion in excel. BIN2HEX formula offers Binary to Hexadecimal conversion in Excel.
Syntax
=BIN2HEX(number, [places])
Parameters
- number: a mandatory parameter, refers to binary number, it should not be more that 10 bits (characters)
- places: its an optional parameter, it pads the value with leading zeros
Formula example

Output

Next >> Convert Binary to Decimal in Excel with example