There will be a message box such as this: Think ahead MsgBox ("There are " & nWord - nNumber & " words in this document, excluding numbers in tables.") NNumber = nWordInNewDoc - nWordInNewDocWithoutNum NWordInNewDocWithoutNum = (wdStatisticWords) ObjRange.PasteSpecial DataType:=wdPasteRTFįor Each objParagraph In ActiveDocument.Paragraphs ObjRange.Collapse Direction:=wdCollapseEnd Sub ExcludeNumbersInTablesFromWordCount()ĭim objDoc As Document, objNewDoc As Documentĭim nWord As Integer, nWordInNewDoc As Integer, nWordInNewDocWithoutNum As Integer, nNumber As Integer Install and run a macro as stated above in method 3.Here is a particular need to exclude numbers in tables from word count. You will receive a message box, telling you how many words there in your document, such as bellow: Method 4: Exclude Numbers in Tables from Word Count MsgBox ("There are " & nWord & " words in this document.") Double click on module to open it and paste the bellowing codes:.Then click “Insert” tab and choose “Module”.Next click “Normal’ in the left column.To begin with, press “Alt+ F11” in Word to open VBA editor.The following macro will do the above steps automatically and return you a message box, containing the total number of words excluding numbers. Similarly, follow step 2 and 3 to format punctuation marks as hidden texts.Next repeat from step 8 to 9 to find all punctuation marks.Instead of deleting selected numbers, press “Ctrl+ D” to open “Font” box.First of all, repeat first 6 steps in method.Word doesn’t include hidden texts in word count, so you can choose to set numbers in hidden formatting. Method 2: Format All Numbers as Hidden Texts Lastly, click “Review” then “Word Count” to view total number of texts.Repeat step 5 to find all punctuation marks.And remember to check “Use wildcards” box.This time input “ ” (without quotation marks) in “Find what” text box. So you need to remove all punctuation marks as well. Once numbers are gone, you can notice Word consider some punctuation marks as words now.You will find all numbers are in selection.Now click “Find In” and choose “Main Document”.If you can’t remember this string, put cursor at “Find what” text box and click “More” then click “Special” button. Next enter “^#” in “Find what” text box.Secondly, choose “Advanced Find” to open “Find and Replace” dialog box.Firstly, open copy file and click the drop-down button on “Find” under “Home” tab.Therefore, we are delighted to show you 4 methods to meet such a requirement.īefore all, you must take a backup of target document and operate all methods bellow on your copy. But, now and then, we are likely to do a word count excluding certain elements, such as numbers. Generally, Word counts all types of texts, be they words or numbers. In today’s article, we will present you 4 effectual ways to exclude numbers in your Word document from word count statistics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |