It seems like every time Microsoft releases a new version of Office, they move everything around! You get used to seeing one thing under one menu and then next version of Office moves that option to another menu! Grrrr. I’ve upgraded to Office 2010 and one of the most common features I use is the Character/Word Count.

  • In Excel, you can also use a macro to count the occurrences of a specific character in a cell, or range of cells. For additional information about counting occurrences of text, click the following article number to view the article in the Microsoft Knowledge Base.
  • How to count number of characters, words and sentences for page or selected text in Word document Word 2016 There are many professionals who need to know statistics numbers for a page or just some selected block in the Word document such as number of characters, words, sentences, etc.
  • Download this app from Microsoft Store for Windows 10 Mobile, Windows Phone 8.1, Windows Phone 8. See screenshots, read the latest customer reviews, and compare ratings for Word Counter.
  • You can view the number of characters, lines, paragraphs, and other information in your Word for Mac, by clicking the word count in the status bar to open the Word Count box. Unless you have selected some text, Word counts all text in the document, as well as the characters, and displays them in the Word Count box as the Statistics.

How to do a word count in TextEdit on Mac. But Microsoft Word and Apple Pages are other options - paste it in with Cmd + V and then do a word count there. (In Google Docs use Tools Word.

Of course, I could not immediately find it and had to go flipping through all the ribbons before I finally saw it! By default, in Word 2010, it’s located on the Review tab under the Proofing section.

Clicking on that will give you not only the number of words, but also other stats like pages, characters with and without spaces, paragraphs and lines.

I still find this quite annoying since I use it so often, so I wanted a quicker way to access this same info. Luckily in Word 2010, there is an option to add the word count to the status bar at the bottom. Just right-click on the status bar and you’ll see an option for Word Count.

Once you select that, you’ll see the word count at the bottom left of the status bar:

That’s pretty much it! If you want, you can also add Word Count to your quick access toolbar by right-clicking on the icon in the Review tab and choosing Add to Quick Access Toolbar.

Now it’ll also show up at the very top, but this is really no different than it being in the status bar, it’s just a personal preference. You have both options.

As an extra bonus, I’ll just throw in a few more features that I used a lot but took a minute to find in Office 2010. For example, where is the Find & Replace in Word 2010? On the home tab, at the very far right, click on Replace.

Where is spell check in Word 2010? Again, this is on the Review tab under Proofing.

And finally where is the developer tab for those of us who need it? For that, you need to click on File, Options and then click on Customize Ribbon. Under Main Tabs, you need to check the box next to Developer Tab.

This will allow you to open Visual Basic and record macros, etc. If you’re looking for something else in Word 2010, let us know in the comments and we’ll get back to you! Enjoy!

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Summary

This article contains and describes formulas that calculate the following:

  • The number of occurrences of a text string in a range of cells.
  • The number of occurrences of a character in one cell.
  • The number of occurrences of a character in a range of cells.
  • The number of words (or text strings) separated by a character in a cell.

More Information

Formula to Count the Number of Occurrences of a Text String in a Range

Microsoft Word Mac Character Count Sheet

=SUM(LEN(range)-LEN(SUBSTITUTE(range,'text',')))/LEN('text')

Where range is the cell range in question and 'text' is replaced by the specific text string that you want to count.

Note

The above formula must be entered as an array formula. To enter a formula as an array in Excel for Windows, press CTRL+SHIFT+ENTER. To enter a formula as an array in Excel for Macintosh, press COMMAND+RETURN.

The formula must be divided by the length of the text string because the sum of the character length of the range is decreased by a multiple of each occurrence of the text string. This formula can replace all later formulas in this article except the formula to count the number of words in a cell.

Twitter Word Count

Example 1: Counting the Number of Occurrences of a Text String in a Range

  1. Start Excel, and then open a new workbook.

  2. Type the following on sheet1:

    The value of cell A8 is 4 because the text 'apple' appears four times in the range.

Formula to Count the Number of Occurrences of a Single Character in One Cell

=LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,'a','))

Where cell_ref is the cell reference, and 'a' is replaced by the character you want to count.

Note

This formula does not need to be entered as an array formula.

Example 2: Counting the Number of Occurrences of a Character in One Cell

Use the same data from the preceding example; assuming you want to count the number of occurrences of the character 'p' in A7. Type the following formula in cell A9:

A9: =LEN(A7)-LEN(SUBSTITUTE(A7,'p','))

2020-3-13  Unable to connect to Sharepoint site through Document Connection. I want to connect to a Sharepoint site but this option is grayed out and I am unable to click on it. How can I fix this? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. You need to have Office for Mac 2011 Home. Microsoft document connection mac sharepoint greyed out. 2012-8-6  Hi trying to use Document Connection for the first time to connect to several SharePoint sites. I can connect to SkyDrive but not Sharepoint, the latter option being greyed out. Reading the forum I.

The value of cell A9 is 3 because the character 'p' appears three times in A7.

Formula to Count the Number of Occurrences of a Single Character in a Range

=SUM(LEN(range)-LEN(SUBSTITUTE(range,'a',')))

Chinese Character Count

Where range is the cell range in question, and 'a' is replaced by the character you want to count.

Note

The above formula must be entered as an array formula. To enter a formula as an array formula in Excel, press CTRL+SHIFT+ENTER.

Example 3: Counting the Number of Occurrences of a Character in a Range

Use the same data from the preceding example; assuming you want to count the number of occurrences or the character 'p' in A2:A7. Type the following formula in cell A10:

A10: =SUM(LEN(A2:A7)-LEN(SUBSTITUTE(A2:A7,'p',')))

Note

The above formula must be entered as an array formula. To enter a formula as an array formula in Excel, press CTRL+SHIFT+ENTER.

The value of cell A10 is 11 because the character 'p' appears 11 times in A2:A7.

Formula to Count the Number of Words Separated by a Character in a Cell

=IF(LEN(TRIM(cell_ref))=0,0,LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,char,'))+1)

Where cell_ref is the cell reference, and char is the character separating the words.

Note

There are no spaces in the above formula; multiple lines are used only to fit the formula into this document. Do not include any spaces when you type it into the cell. This formula does not need to be entered as an array formula.

Example 4: Counting the Number of Words Separated by a Space in a Cell

Microsoft Word Mac Character Country

Microsoft word mac character countries

To count the number of words in a cell where the words are separated by a space character, follow these steps:

  1. Start Excel, and then open a new workbook.

  2. Type the following on sheet1:

The formula in cell A2 returns a value of 4 to reflect that the string contains four words separated by spaces. If words are separated by multiple spaces or if words start or end in a space, it does not matter. The TRIM function removes extra space characters and starting and ending space characters in the text of the cell.

How Many Characters

In Excel, you can also use a macro to count the occurrences of a specific character in a cell, or range of cells.

References

For additional information about counting occurrences of text, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft Word Mac Character Counter

89794 How to use Visual Basic for Applications to count the occurrences of a character in a selection in Excel