Formula for converting 32 bit Hexadecimal into decimal in EXCEL

nigel_cro · Dec 3, 2009, 07:17 AM

JB,

At the risk of being a complete PITA - I need to take a hex string (eg D0 boyfriend FF FF) and turn it to Little endian (eg FF FF boyfriend D0). I have tried to adapt some of your coding from your really helpful posting above but my VB skills are, frankly, appalling and while I can work out what your script is doing, I am not having any success in adapting it.

I'm sure this is a relatively simple couple of lines but it is beyond me.

Thanks, in advance for any help,

Nigel

JBeaucaire · Dec 3, 2009, 10:17 AM

If your text string in A2 is shown exactly like you demonstrated above with spaces between each quad, then use this worksheet formula to reverse the order of the quads:

=RIGHT(A2,2) & MID(A2,6,4) & MID(A2,4,3) & LEFT(A2,2)

If your data does not match this exact format, click on GO ADVANCED and use the paperclip icon to upload a sample worksheet with several examples of your data and your desired results.

nigel_cro · Dec 3, 2009, 12:53 PM

JB,

Thanks for the really prompt response.

I knew I would get something wrong - I would like to input the HEX string as a continuous string, it makes the inputting process a whole lot easier, to have to include spaces would build unnecessary effort and room for error into the process.

So, the actual input will look like [D0BFFFFF] and the output would look similar [FFFFBFD0]. Just to emphasise, both input and output would be in continuous strings.

I'm sorry to have wasted your time, thanks for the help.

All the best,

Nigel

JBeaucaire · Dec 3, 2009, 04:19 PM

Hopefully you'll pull these two examples apart and see what's going on so you can use this technique yourself in the future.

This is for reversing your text string 2 characters at a time with no spaces:

=RIGHT(A1,2) & MID(A1,5,2) & MID(A1,3,2) & LEFT(A1,2)

shanemacdonald · Dec 23, 2009, 11:06 AM

Can't seem to get the hextosng function to work with Office 2007. Are there any known issues with this?

shanemacdonald · Dec 23, 2009, 11:08 AM

My post was with regards to the formula for converting 32 bit hexadecimal into decimal in EXCEL... Cheers, Shane

JBeaucaire · Dec 23, 2009, 11:33 AM

Were you going to post a workbook with the function installed in it and NOT working as expected? Do so, be sure to highlight the cells with the function(s) in use so I don't have to hunt for them.

shanemacdonald · Dec 23, 2009, 12:11 PM

I saved, closed and reopened Excel - all seems good.

Thanks,

Shane

kishorekumar88 · Dec 8, 2010, 05:46 AM

How to convert from Float number to 32 bit Hex ?

besjon · Apr 25, 2011, 02:08 AM

How to convert this hexadecimal code 2fb2644b98dd3c99be2661cd41ca2f11 in letters please?

Formula for converting 32 bit Hexadecimal into decimal in EXCEL

Add your answer here.

Check out some similar questions!