I’m looking for a way to find a proper name within a cell of text. I have a scrape from a webcrawl that contains the body of websites and often times the metadata for author isn’t actually the person who authored the article. What I think might work is, using VBA in excel, if I could find any occurrences of two, three or four words in a row that start with a capital letter. Once they have been found they would be put in the adjacent cell.

Example:

Column A ------------------------------------------Column B
This would be the text. Alan Smith. Blah blah.--------Alan Smith
More text. Blah blah. Dr. T. G. Gordon.----------------Dr. T. G. Gordon

Any Ideas?