HowdeeDoodee
Well-known Member
- Joined
- Nov 15, 2004
- Messages
- 599
I need to replace the stop words in the contents of this column whose data description is shown below. Numerous macros and vb routines have all hung up my system. Column B contains the stop words I want to find and replace with a dummy character = to [XXXX]. Column C contains the dummy character, filled down to the bottom of the sheet. Column D contains the document whose characteristics are shown below. In Column D, each cell is filled with one sentence where the sentence equals one paragraph. The stop words to be replaced with the dummy character are in column D. Column D contains 1136 rows or sentences. Column B contains the 1100 stop words.
| Words | 20097 |
|---|---|
| Characters | 105855 |
| Sentences | 1365 |
| Lines | 1036 |
| Paragraphs | 1035 |
| Numerals | 1 |
| Punctuation | 2092 |
| Average Read Time | 1 hour, 40 minutes 29 seconds |
| Average Spell Time | 2 hours 13 minutes 58 seconds |
| Pages (A4) | 40 |
