Excel function/macro -- extract proper nouns
Posted on 2013-12-04
Need some help with developing -- if all possible -- a function/macro -- that scans through a single columns (in a spreadsheet) and "detects" all proper nouns.
Then, in step #2, it would add only the nouns into another column (separated by commas).
For example, I may have the following two (2) sentences in column A:
The agency made the announcement late Tuesday night, hours after a union representative told CNN that the train engineer apparently "was nodding off and caught himself too late" before the accident.
On Monday, one of the nation's most esteemed weeklies, New York magazine, announced that it would soon shift to an every-other-week publishing schedule while beefing up its Web production.
Then, once the function/macro has been applied, I'd like to see the following nouns in column B:
B1: agency, announcement, union, representative, train, engineer, accident
B2: nation, magazine, schedule, production
Note: In actuality, I have thousands of strings in column A. Some of them are short... some of them are longer.
Even if I only get the 80% solution, I certainly would be a huge time saver.
Any thoughts on how to accomplish this task?