| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hexadecimal to binary
A very good solution. Once I realized that HEX2BIN was really just playing
with strings, solutions became a lot easier to find. Have a pleasant weekend -- Gary's Student " wrote: Found it. =HEX2BIN(LEFT(A3,2),8) & HEX2BIN(RIGHT(A3,2),8) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change hexadecimal number to binary in excel | Excel Worksheet Functions | |||
| Is there a way to count higher than 511 in binary in excel? | Excel Worksheet Functions | |||
| Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
| binary bit word | Excel Worksheet Functions | |||
| Binary Numbers longer than 10 characters | Excel Worksheet Functions | |||
Threaded Mode
