How to convert hex to binary in Excel?
Hex numbers and binary numbers are usually used in computer technology, but do you know how to convert hex numbers to binary numbers and vice versa? Now I will tell you the easy way to solve the conversion between hex and binary in Excel worksheet.
There is a formula can convert the hex number to binary number.
Select a blank cell adjacent to the hex number cell, and type this formula =HEX2BIN(A2) (A2 stands for the cell you want to convert) into it, and press Enter key to apply this formula, and if you need, you can drag its AutoFill handle to a range. See screenshot:
In reverse, if you want to convert binary number to hex number, you can use below formula.
Select a blank cell adjacent to the hex number cell, and type this formula =BIN2HEX(A2) (A2 stands for the cell you want to convert) into it, and press Enter key to apply this formula, and if you need, you can drag its AutoFill handle to a range. See screenshot:
Best Office Productivity Tools
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!