Hexadecimal to decimal.

Hey All,

In the attatchment I have multiple hexadecimal numbers which I would like to be shown as decimal numbers next to hexadecimals. On the attatchemnt there is also instructions which digits are measuring values and which are something else. There is also mention about which value is LSB. I would like to have function how to convert those values easily to decimals but I do not have idea how to convert that long hexadecimals to decimals.
Could somebody help me to make that function?

Thank you in advance,

Best regards,
Eemilv

could you show a part of a string to convert

with your example you can try: =HEX2DEC(LEFT(SUBSTITUTE(A2," ",""),8))

Originally Posted by sandy666

with your example you can try: =hex2dec(left(substitute(a2," ",""),8))

=hex2dec(mid(substitute(a2," ",""),7,8))

The last value (aa 00 00 00) as LSB is 170. This formula gives me 2852126720. Excel reads spaces as values when picking values with MID function so i think it should be =hex2dec(mid(substitute(a7," ",""),10,8))
, but in this case it gives me 0.

To me LSB is LowerSideBand (from KF radio)

Oh I see , In this case it means little endian. That basically means that least significat value is the first one. For example if I had hexadecimal 7DE in LSB, E would be most significant number and 7 least significant. And as excel uses MSB in calculations before using HEX2DEC I should turn these numbers around being ED7. Now here in my hex number if we take last row (aa 00 00 00) it means aa is least significant number as pair of numbers seems to be one value in this case. Before calculating this I need to turn these around being 00 00 00 aa. Hopefully this helps

=HEX2DEC(LOOKUP(2,1/(TRIM(MID(SUBSTITUTE(A2,0," "),ROW(INDIRECT("1:12"))*3-2,3))<>""),MID(A2,ROW(INDIRECT("1:12"))*3-2,2)))

what about BruteForce way?

=HEX2DEC(MID(A2,19,2)&MID(A2,16,2)&MID(A2,13,2)&MID(A2,10,2))

Thanks for everybody on replys! Sandy666 your function works perfectly! Thank you for that. This was my first time using excelforum for help and problem is solved in less than 3 hours, PERFECT.

0

Long formula but it is working for 64-HEX characters:


=HEX2DEC(MID(A24,1,8))*4*2^512+HEX2DEC(MID(A24,9,8))*2*2^512+HEX2DEC(MID(A24,17,8))*2^512+HEX2DEC(MID(A24,25,8))*2^256+HEX2DEC(MID(A24,33,8))*2^128+HEX2DEC(MID(A24,41,8))*2^64+HEX2DEC(MID(A24,49,8))*2^32+HEX2DEC(MID(A24,57,8))


note: all 64 character must be present like the following example:

"0000000000000000000000000000000000000000000000000000000000000fd1"

Cheers