Excel BIN2HEX Function

What is BIN2HEX function in Excel?


The BIN2HEX function is one of the Engineering functions of Excel.

It Converts a binary number to hexadecimal.

We can find this function in the Engineering category of insert function Tab.

How to use BIN2HEX function in excel

  1. Click on an empty cell (like F5 ).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Engineering category.

5. Select BIN2HEX function.

6. Then select ok.

excel BIN2HEX function

7. In the function arguments Tab you will see BIN2HEX function.

8. Number section is the binary number you want to convert.

9. Places is the number of characters to use.

10. You will see the results in the formula result section.

How to use BIN2HEX function in excel

Examples of BIN2HEX function in Excel

Example 1:

How to use BIN2HEX function in excel

You can see examples of BIN2HEX function below:

Examples of BIN2HEX function in Excel
bin2hex(A2) ----->>>>answer is  7F

bin2hex(A3) ----->>>>answer is  5C

bin2hex(A4) ----->>>>answer is  4F

bin2hex(A5) ----->>>>answer is  FFFFFFFE01

bin2hex(A6) ----->>>>answer is  13F

Purpose of BIN2HEX function

It Converts a binary number to hexadecimal.

Return value of BIN2HEX function

It returns a number and data.

Arguments of BIN2HEX function

This function has just 2 Argument.

The argument of BIN2HEX function is number.

Number section is the binary number you want to convert.

Places is the number of characters to use.

The argument of BIN2HEX function is required and not optional.

BIN2HEX(number) = number

Version of excel supports BIN2HEX function

This function is available for all excel versions (2003-2019)

Errors in BIN2HEX function

BIN2HEX related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *