Counting Words the Old Fashioned Way

You probably already knew that Word provides a way to determine the number of words in a selection or in your entire document. Word has its own internal algorithms to figure out the proper count. This is great, if you need to know actual word counts.

Before the days of actual word counts, however, typists figured out the number of average words in a document. This was done by figuring out the number of characters typed, and then dividing that figure by five. For some purposes you may still need to figure word counts using this old-fashioned approach. This can be done with a simple macro, as follows:

Sub WordCount()
    Dim Title As String
    Dim WordCount As Integer
    Dim Message As String

    Title = "WordCount"
    WordCount = Int((Len(Selection) / 5) + 0.5)
    Message = LTrim(Str(WordCount)) + " word"
    If WordCount <> 1 Then Message = Message + "s"
    MsgBox Message, vbOKOnly, Title
End Sub