cyber-33
asked on
Unique word identification in excel documents
I am looking for a macro that can take an excel spreadsheet and generate a text file containing a list of UNIQUE words used in the spreadsheet. Some spreadsheets can contain as many as 80,000 words....
Note: individual cells can have multiple words separated by spaces.
A sample input files is attached
Thank you!
OFX-2.1.1.txt
Note: individual cells can have multiple words separated by spaces.
A sample input files is attached
Thank you!
OFX-2.1.1.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
You're welcome.
Sorry, I'm confused by your attached file.
Is this a text file you wish to open in MS-Excel & then produce another text file containing the unique words, or is this the resultant file after the required process is complete?
Perhaps you could attach an example MS-Excel workbook instead, so that it is clear what is required.
Thanks.
BFN,
fp.