• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 742
  • Last Modified:

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.
0
UserValerie
Asked:
UserValerie
1 Solution
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now