To display extended statistics, double click the word count in the status bar or choose Tools/Word Count. LibreOffice Writer shows the number of words and characters on the status bar. Then, click Word count to find the total number of words, characters, and pages.Alternatively, on the Review tab, click Word Count to see the detailed statistics (shortcut Ctrl+Shift+G).Ĭheck Display word count while typing and then click OK to find the word count while you type or do the following: If you do not see the word count in the status bar, do the following:įind the number of words, characters, paragraphs, and lines by clicking on the displayed word count in the status bar. Microsoft Word automatically displays the number of words in your document on the status bar. Notice that we now show two 'surgery' words instead of just one.Įxcel can do some pretty amazing things, but sometimes you have to get creative to achieve the end result.Follow the instructions below to determine the exact word count in your favorite word processor. Then we could use COUNTIF on the split data. What if we wanted a more accurate count? We could use Excel's Text-to-Columns feature to split the text at spaces: (The asterisks are wildcard characters that match any text before or after the word.) If there's more than one 'Delete' in a cell, it will only count it once, so this isn't flawless, but it gives a good estimate. This formula will find every cell that has the word in cell C2 embedded in the text. If we use a link to another cell ('=*'&C2&'*') that contains a word, we can make one formula work for any word. I could use the formula =COUNTIF($A$2:$A$10,'=*Delete*'), but I'd have to change the word 'Delete' every time I wanted to add a new word. We need to use the fixed range ($A$2:$A$10) so that we can copy the formula.

Just type or paste your text into our free online word count tool.

If we take the Word Count data in QI Macros Test Data/Pivottable.xlsx, we just need to add a formula. Word Count A simple and free word counter Instantly check your word and character count. It's not hard, but I needed to make it simple enough that I could change words in and out. When I first started analyzing data collected by call center reps, I had to figure out how to use COUNTIF.

But what if you want to count the specific words used in text? A QI Macros customer was trying to determine the frequency of a glossary of words in text, but wasn't sure how to go about it. QI Macros Word Count wizard will parse all of the text selected and give you a sorted list of those words. Using Excel's COUNTIF Function to Count Specific Words QI Macros Tips » Counting Specific Words with COUNTIF Free Agile Lean Six Sigma Trainer Training.Animated Lean Six Sigma Video Tutorials.

Counting words in word