Question Locked

How to extract text data from excel records into a single text file.

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi guys,

In my work, I have a Field in Excel which stores text(about 1000 characters per record).

I am interested in combining all the records into a single large text file(.txt).

Does anyone know how I might go about this? I am thinking of using a C script or VBA but I dont know HOW to actually do it.

Any inputs or suggestions welcome.

3 replies

by bizzo

Not quite clear on what your after.
Is this going to be a regular task that you want to automate, or just a one off?

If it's a one off task, then copy the column that you want to export and just paste into notepad.
if this is too large, copy to another workbook and save as .csv

by chibuikei

Sorry about the vagueness.

Its a regular task I want to automate.

I want to find out the frequency of occurence of certain keywords across a Field (which stores text as memo(i.e. large anount of characters per record)).

I am thinking XML or a scripting or???

ANy suggestions at all welcome.

This discussion is closed to new replies.