I have about 10,000 hexadecimal numbers (32 digits each) in an excel file, in one column. I want to verify that all of them are indeed hexadecimal number and that no other characters are present. My first thought was to import them into a list and then apply 16^^# to the list and see if I get any errors. This doesn't seem to work because the import is bringing them in as strings. I can't figure out how to convert the strings to something that 16^^ will work on. Is there something I can do?
Another approach, which I didn't try would be using regular expressions to validate that only proper characters are in each number. I almost never use regular expressions, so a hint along those lines would be helpful.
If there's a better approach I would love to hear it.
I'm using Windows 7, Mathematica 10.0.2.0, Excel 10.