Hello all,

I am new here, and couldn't find much info about this topic from searching the forum, so I hope I am not being repetitive when I ask this question:

I am importing large .txt files to Excel 2010, and need the data that is imported to be validated (simple validations - certain fields need to contain only numerical values, certain other fields need to contain only alphabetical characters, etc.). I am unaware of how to do this. I am only able to do validation manually after importing the .txt files, which takes quite a while considering I have many files I need to validate after importing.

I'm no Excel expert, but I assume that there has to be a way to automatically validate data as it is imported? Let me know.

Thanks in advance for any help you may be able to provide!

golfrguy04