Importing hex data to a hex string in excel using VBA

[r.l.blair.tech]

I am using excel to do quick analysis on Ethernet Packet Data
I have read VBA for dummies and while it was kind of helpful It really wasnt what I needed

It would be incredibly usefule to import the data (in one large cell) into a string and label it as an actual hex valued string . I do NOT want the ascii value of F3 I want the actual value 0xF3. It doesnt need the 0x prefix (unless excel requires it).
Anybody know any good VBA books or web pages on data strings, Data Matricies, and importing and manipulating data in hex.

Thanks

 

[Ruddles]

Anybody know any good VBA books or web pages on data strings, Data Matricies, and importing and manipulating data in hex.

Not really, but if you show us your raw data I'm sure someone will be able to write something which you can either use directly, or adapt to suit your exact purpose.