Training Lady,
The text was emailed to me as a word doc and they would like it put in excel as columns. I have no problem copying it to excel and using the text to column function however, there is a lot of data that needs to have commas inserted, periods removed, dates standardized in order to sort them in excel. The sample I put in my original thread shows a few lines of the data that I received.
Thank you!