Thiyagu8423
New Member
- Joined
- Aug 21, 2020
- Messages
- 15
- Office Version
- 2013
- Platform
- Windows
I have 26byte number in one cell , can I convert it to Hexadecimal using formula in one shot
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Binary | Hexadecimal | Binary | Hex | ||||
2 | 11100101011110001110001011101110001110110101000001010101010101000011100011110101010101010101110001110111 | E578E2EE3B50555438F5555C77 | 0000 | 0 | ||||
3 | 0001 | 1 | ||||||
4 | E | 0010 | 2 | |||||
5 | E5 | 0011 | 3 | |||||
6 | E57 | 0100 | 4 | |||||
7 | E578 | 0101 | 5 | |||||
8 | E578E | 0110 | 6 | |||||
9 | E578E2 | 0111 | 7 | |||||
10 | E578E2E | 1000 | 8 | |||||
11 | E578E2EE | 1001 | 9 | |||||
12 | E578E2EE3 | 1010 | A | |||||
13 | E578E2EE3B | 1011 | B | |||||
14 | E578E2EE3B5 | 1100 | C | |||||
15 | E578E2EE3B50 | 1101 | D | |||||
16 | E578E2EE3B505 | 1110 | E | |||||
17 | E578E2EE3B5055 | 1111 | F | |||||
18 | E578E2EE3B50555 | |||||||
19 | E578E2EE3B505554 | |||||||
20 | E578E2EE3B5055543 | |||||||
21 | E578E2EE3B50555438 | |||||||
22 | E578E2EE3B50555438F | |||||||
23 | E578E2EE3B50555438F5 | |||||||
24 | E578E2EE3B50555438F55 | |||||||
25 | E578E2EE3B50555438F555 | |||||||
26 | E578E2EE3B50555438F5555 | |||||||
27 | E578E2EE3B50555438F5555C | |||||||
28 | E578E2EE3B50555438F5555C7 | |||||||
29 | E578E2EE3B50555438F5555C77 | |||||||
Sheet5 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =CONCAT(BIN2HEX(MID(A2,SEQUENCE(LEN(A2)/4,,,4),4))) |
B4:B29 | B4 | =B3&VLOOKUP(MID(A$2,ROWS(A$4:A4)*4-3,4),$E$2:$F$17,2,0) |
Appreciate for help...will try tomorrowMaybe...
=CONCAT(BIN2HEX(MID(A2,ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A2)/4))*4-4+1,4)))
Hope this helps!