Condensing a set of notes

[leeroyhightower]

I need to create something that would take a group of notes that contains about 1,000 words or so and deletes all of the repetious phrases that it finds.

For example, when it finds the paragraph:

"This paragraph is repetition and thus appears at least 4 times but not more than 10. I need only to keep one instance of it and delete each additional one."

I just want to keep it the first time I see it.

Also, I want to create something where I would be extract key words and the text that follows.

For instance,

Problem: chain does not move

OR

Problem: system doesnt respond

Or

Problem: worked yesterday but not today....

 

[Smitty]

Welcome to the Board!

Not that it's going to make your task any easier, but why are you aggregating this information in Excel?

You could possibly look for the instances of "Problem:"?

 

[leeroyhightower]

I'm under the impression that it needs to be a macro and this is the first step. If there is a better easier way I'm certainly open to it.