Extract misspelled words in Microsoft Word or Excel

In long lists of words, one to a line, I need to extract those that are misspelled or, alternatively, extract those that are spelled correctly and leave the ones misspelled.  The bottom line is that I need to be able to separate misspelled from correctly spelled words but do not want to add the misspelled words to the custom dictionary.  Is there way to do identify these words and do this?  I do not mind doing this in either Word or Excel.  Thank you.
UserValerieAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
This is a Word macro.
It will list the misspelings, one per line,  in a new document .
Sub ExtractMisspellings()
    Dim wd As Range
    Dim docA As Document
    Dim docB As Document
    Dim spelSuggs As SpellingSuggestions
    
    Set docA = ActiveDocument
    Set docB = Documents.Add
    For Each wd In docA.Words
        Set spelSuggs = wd.GetSpellingSuggestions
        If spelSuggs.Count > 0 Then
            docB.Bookmarks("\EndOfDoc").Range.Text = wd.Text & vbCr
        End If
    Next wd
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.