I'm trying to pull some text out of a lengthy excel document to do some text
mining on. I'd like to have a macro (or another solution that would work) to
pull the headers out of each line (record) and save each line as a text file.
Any help would be greatly appreciated!
Thanks
So, if I had an excel (.csv file) file that captured email content (someone
in the past did this manually) like this:
Subject,Body,Date
Lunch Plans,Do you have lunch plans?,4/5/2006
What's Up?,What are you up to today?,4/5/2006
Would be converted to 2 .txt files like this:
Text File 1:
Subject:
Lunch Plans
Body:
Do you have Lunch Plans?
Date:
4/5/2006
Text File 2:
Subject:
What's Up?
Body:
What are you up to today?
Date:
4/5/2006
Bookmarks