Conversion from hex to ASCII

[Joseph Chamberlain, DDS]

Dear All:

I am interested in knowing if Excel has functions that allow the opening of
a hexadecimal file and have it converted to ASCII characterers.

I've trying to open digital camera RAW files and have access to information
in it. I've tried a few different hex editors for the Macintosh but found
all to be underpowered and to lack the features found in Excel. Since Excel
has the ability to import data and other files, I thought it might be more
powerful than all the hex editors I have reviewed so far.

The hexadecimal data may be either imported as one single piece of
information into a single cell (this would be a huge cell) or it may
(depending on how the manufacturer of the camera has the hex data layed out)
in pre-defined pieces that can be imported into individual cells in much the
same manner as tab delimited files have their different fields placed each
into a different cell.

Can this be done with Excel ? Any help will be greatly appreciated.

Thank you in advance,

Joseph

 

[JE McGimpsey]

Can this be done with Excel ? Any help will be greatly appreciated.

Not sure what exactly a "hexadecimal file" is - in general, files are
read as binary or text.

Nor am I sure how you'd do the conversion. Would you expect a
hexadecimal 0a to convert to an ASCII LF (e.g., CHAR(10)) character?

One can read in binary files using VBA