Convert Hex values to Binary

Good afternoon,

I have a Excel-file with Hex decimals. I want to convert these to Binary. I found some VBA code that looks like:

Please Login or Register  to view this content.

The Hex decimals starts in cell A1. How can I insert the 'strBytes' in the code link to a cell or column?

It will looks like: strBytes = "Range.Select ("A1:A47")". Is this possible?

Already thanks.

What are some typical entries in A1? What form of hex decimals are you using? e.g. is there a preceding $, is there a space between each 4th digit. Is each entry 8 digits long?

Have you looked at the HEX2BIN function?

Example:
I have the following code in cell A1:

Please Login or Register  to view this content.

When I fill in this code in VBA for 'strBytes', the outcome of the .bin file is:

Please Login or Register  to view this content.

This is what I want the file will look like, but then I want select some range in Excel to get the 'strBytes' code from.

I have looked at HEX2BIN, but this isn't where I'm looking for. I want to open the extracted file from the VBA code in HexEdit to see the code from cell A1.

You could use this UDF, with a formula like =HexToBin(A1)

Please Login or Register  to view this content.

Originally Posted by Schiavoni

Example:
I have the following code in cell A1:

Please Login or Register  to view this content.

When I fill in this code in VBA for 'strBytes', the outcome of the .bin file is:

Please Login or Register  to view this content.

HEX2Bin isn't the thing I'm looking for.

Your Subject header rather belies that last statement.

What results do you expect to see?

In answer to your last question you could include a loop to build the string

Please Login or Register  to view this content.

It looks like you could skip strBytes altogether and just use:

Please Login or Register  to view this content.

then just amend the loop to refer to arrBytes(i, 1) rather than just arrBytes(i)

Originally Posted by rorya

It looks like you could skip strBytes altogether and just use:

Indeed....even better

As I mentioned, if you populate the array from a range, you need to alter the code in the loop too, since it's a 2d array:

Please Login or Register  to view this content.

Does each cell in A1:A47 contain a string like "F3 A1 02 00 04 00 8D 24 44 C3 8C 03 83 49 26 92 B5", or is it one hex char per cell?

Originally Posted by huuthang_bd

Try this

Please Login or Register  to view this content.

This code is working. Thanks!

Now I have in column A the merged Hexcodes. Is it possible to change the range to: A1:BL46 and A47:D47 together?

In this range each cell contains a hex code with 2 characters.

You can change the range if you want.

Please Login or Register  to view this content.