Closed Thread
Results 1 to 2 of 2

Identifying Repeated Words in a Word Doc, Outputting to Excel

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Washington, DC
    MS-Off Ver
    Windows 10 Pro
    Posts
    5

    Identifying Repeated Words in a Word Doc, Outputting to Excel

    Hi All,

    I tend to write a lot of prose in Word and worry that sometimes I repeat adjectives/verbs too closely together. For example, I wouldn't want to use a word like "plethora" in a sentence, and then use it again a few sentences later. Is there a way to write a macro that can review an entire Word document and output an excel file that lists any words over 4 characters in length that are repeated? Something like a list of repeat words in column A, then the number of occurrences in column B.

    This is what I'd like to do but I'm totally lost as to how to even get started. I have a decent background with VBA for excel applications, but I've never tried it with Word. Any input is graciously accepted - thank you!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,844

    Re: Identifying Repeated Words in a Word Doc, Outputting to Excel

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Repeated words: remove duplicates, display word along with the number of times repeated
    By number9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-24-2019, 03:32 PM
  2. Replies: 1
    Last Post: 05-18-2018, 06:38 AM
  3. [SOLVED] How to set repeated words as misspelling?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2017, 10:48 PM
  4. Replies: 3
    Last Post: 07-15-2014, 03:42 PM
  5. Replies: 0
    Last Post: 06-13-2012, 09:16 PM
  6. Replies: 2
    Last Post: 06-24-2008, 05:07 PM
  7. Repeated words in spellcheck
    By Kushami in forum Excel General
    Replies: 1
    Last Post: 05-17-2006, 10:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1