How to use the OCT2HEX Function in Excel Spreadsheets?
Tags: tousetheoct2hexfunct, excel, excelfunctions
Published: 2021-08-27 02:09:38

---
title: How to use the OCT2HEX Function in Excel Spreadsheets?
published: true
date: 2021-08-24 16:03:43 UTC
tags: ToUseTheOCT2HEXFunct,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-oct2hex-function-in-excel-spreadsheets/
---

In this article, you will learn how to use **OCT2HEX Function in Excel 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## OCT2HEX – Function Explanation

- **OCT2HEX function** is mainly used to convert **octal representation of numbers of radix 8 to hexadecimal numbers**.
- This function is just opposite to **[HEX2OCT Function](https://geekexcel.com/how-to-use-hex2oct-function-in-microsoft-excel-365/)**.

## OCT2HEX Function Syntax

```
=OCT2HEX ( number, [places] )
```

**Syntax Explanation:**

- **Number** : Octal number, which returns the 10 character hexadecimal number.
- **[Places]** : [optional] number, where result expressed up to the number.

## Example

- Firstly, you need to **create a sample data** with **octal values**  **in Octal Column**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-30.png)<figcaption>Sample data</figcaption>

- Then, you have to convert these **octal numbers**  **to hexadecimal value**.
- Now, you need to use the following **formula** given below.

```
=OCT2HEX (A2)
```

**A2:** number provided to the function as a cell reference

![](https://geekexcel.com/wp-content/uploads/2021/08/Use-the-formula-3.png)<figcaption>Use the formula</figcaption>

- After that, the **OCT2HEX** representation of **2 of base 8** (hexadecimal) is **10 of base 2** (decimal).
- Now, you have to copy the **formula to other cells** using the **Ctrl + D** shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Copy-the-formula-to-other-cells-1.png)<figcaption>copy the formula to other cells</figcaption>

**Check this too:** [How to Use HEX2BIN Function in MS Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-hex2bin-function-in-ms-excel-365-with-examples/)

## Verdict

We hope that this short tutorial gives you guidelines to **use the OCT2HEX**  **Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to use the PROB function in Excel Spreadsheets?](https://geekexcel.com/how-to-use-the-prob-function-in-excel-spreadsheets/)**
- **[How to Select Cells Based on Color/Formatting in Excel Office 365?](https://geekexcel.com/how-to-select-cells-based-on-color-formatting-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Tax Rate with Fixed Base with IF Function!](https://geekexcel.com/excel-formulas-to-calculate-the-tax-rate-with-fixed-base-with-if-function/)**
- **[Add Leading Zeros in Excel 365 – [Simple and Quick Ways in Excel]](https://geekexcel.com/add-leading-zeros-in-excel-365-simple-and-quick-ways-in-excel/)**
- **[Excel Formulas to Covert Numbers into Text ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-covert-numbers-into-text-a-complete-guide/)**