Hi All,
This may not be complex to the power users, but I'm struggling to come up with this formula for B2 and C2. Here is what I'm trying to do:
Take the value in A2 (141635858), which is the only known value and convert it from DEC2HEX resulting in 8713108. Then take only the 5 numbers from the left (87131) and convert that from HEX2DEC resulting in 553265. I need this number (553265) in B2. Then the last two numbers of 8712108 (08), I need to convert from HEX2DEC and populate that result in C2 (8).
Any help with these formulas in B2 and C2 would be much appreciated.
<tbody>
</tbody>
This may not be complex to the power users, but I'm struggling to come up with this formula for B2 and C2. Here is what I'm trying to do:
Take the value in A2 (141635858), which is the only known value and convert it from DEC2HEX resulting in 8713108. Then take only the 5 numbers from the left (87131) and convert that from HEX2DEC resulting in 553265. I need this number (553265) in B2. Then the last two numbers of 8712108 (08), I need to convert from HEX2DEC and populate that result in C2 (8).
Any help with these formulas in B2 and C2 would be much appreciated.
A | B | C | |
1 | VALUE | PAC | PID |
2 | 141635848 | 553265 | 8 |
<tbody>
</tbody>