How to calculate the number of characters in Word, Open Office and Excel

Anyone whose work involves translating or writing from time to time is necessary to count the number of characters in the text, taking into account gaps or without.How to do it?

In Word

In Microsoft Word count characters by using the "Statistics" in the "Tools" menu.Find function in the specified path can be in all versions of the program.Word Statistics show the number of words, characters with spaces or without spaces, double-byte and single-byte characters (for word processing is not necessary), as well as lines, pages and paragraphs.

function is activated after the block of text will be highlighted in a special window will display information about its length.Otherwise, you will get information about the document.

The following versions of Word 2007 with frequent use it is advisable to transfer the function to the toolbar.To do this, you can drag the window that appears to the statistics, or right-click on the panel and mark the list item "Statistics".

In Word 2007 and 2010, the number of words in the document can be seen at the bottom left.If you double-click on the site, a window will appear with the other items statistics.

You can also count the number of characters in a document without spaces using the fields.Place the cursor at the location where you want to see the field.

For Word earlier:

  • In the "Insert" menu, select "Field."A dialog box appears.
  • In the left pane, you will be offered to select the category field and its importance.In the category, select "On paper," and in the values ​​- NumChars.
  • Click OK, and the specified location will figure indicating the number of characters.

For Word 2007 and 2010:

  • In the "Text" tool, select "Insert" & gt;"Quick Insert", and then - the point "field."
  • Select the category "On paper" and the value of the NumChars.
  • Click OK.

The contents of the field (number of characters) must be updated after each save the document.If the field is not updated automatically, right-click on it you need to open the context menu and there choose "Update Field."

in Open Office

to count the number of characters in the document Open Office, do the same as in Word.Statistics is in the menu "Tools" & gt;"Word Count".However, it is not so detalizovannye as in Word.A popup window will show only the number of words in the document (or the selected passage) and the number of characters with spaces.

If you want to find the number of characters without spaces, you must go to search the document and enter in the field expression [: space:] * - it means a space.By clicking on "Find all", you can see the number of spaces in the text, which will need to be subtracted from the figures obtained for the characters with spaces.

In Excel

With the function LEN () and LEN (), you can count the number of characters in a cell.The resulting value will be taken into account not only the spaces but also marks the transfer if the cell was placed with the text paragraph breaks.

Despite these shortcomings, the function is useful, for example, when working with large amounts of text when the character count is only one of a number of problems.With the help of some other formulas in Excel, you can keep details of texts considered symbols without spaces and eliminating some of the other (the Latin alphabet, punctuation marks, numbers).

However, if you want to count the number of characters without HTML-tags or any other options, it is better to turn to special programs or online services.