How to count the number of words in an Excel spreadsheet cell

In Microsoft Office Excel, you can count the number of elements written in the cells of a table array. For this, a simple formula is usually used. Detailed information on this topic will be presented in this article.

Methods for counting words in Excel cells

There are several common ways to accomplish a given task, each of which requires deep study to fully understand. Next, we will talk about the simplest and most effective of them.

Method 1: manual calculation

This method is not quite suitable for MS Excel, regardless of its version, because. this program uses automated calculation tools. However, it is also advisable to consider the manual account within the framework of the article. For its implementation it is necessary:

1. Compose the original table array.
2. Select by pressing the left mouse button the cell in which you want to count the words.
3. Count the collected items.
4. In order not to lose your own time, you can copy the contents of the cell, which is entirely displayed in the line for entering formulas, and paste it into the working field of a special site for quickly counting the number of characters, words.

Pay attention! Counting words in Excel cells manually is not practical if the table contains too much information.

Method 2: Using Microsoft Office Word

In a text editor, all typed words are automatically counted and their number is displayed on the screen. To use this method, the Excel user will need:

1. Highlight the LMB of the words in the tablet cell in order to further calculate their number.
2. Switch the keyboard to the English layout and simultaneously hold down the “Ctrl + C” keys to copy the selected characters to the clipboard.
3. Open text editor MS Word.
4. Place the mouse cursor at the beginning of the working field of the program and press the “Ctrl + V” buttons from the keyboard.
5. Check result. The copied elements from Excel should be pasted into Word without any problems.
6. Pay attention to the lower left corner of the program worksheet. The taskbar will indicate the number of words that are currently typed.

Additional Information! Excel does not have a tool for counting words in cells, because this software is not designed to work with text.

Method 3: Applying a Special Function

This is the most optimal and fastest method for counting words in cells, Excel sentences. To quickly find out the number of required elements, the user will need to take several steps according to the algorithm:

1. Select any empty cell on the worksheet of the program. The result of the calculations will be displayed in it in the future.
2. Place the mouse cursor in the line for entering formulas at the top of the program and write the following expression from the keyboard: “=LENGTH(TRIMSPACES(argument))-DLSTR(SUBSTITUTE(argument;» «;»»))+1».
3. Instead of the word “Argument”, the address of the cell in which the calculation is performed is indicated.

4. After writing the formula, you must press “Enter” to confirm it.
5. Check result. The previously selected cell will contain a number corresponding to the number of words of the element in question.

How to count the number of characters in an Excel cell

Sometimes Excel users need to count the number of characters in a particular cell of a table array. Counting symbols is easier than words. There are several methods for this purpose, which will be discussed below.

Method 1: manual calculation

This method is similar to the previous method discussed in the first part of the article. To implement it, the user will need to select a specific cell of the plate and count each character in it.

Important! There can be a lot of characters in the cells of a Microsoft Office Excel table, which will take a considerable amount of time to manually calculate. Therefore, manually counting is relevant when it comes to a small plate.

Method 2: Using a Function to Count the Length of a String

Excel has a special formula that allows you to count the elements in a row. To use it, you need to do a number of simple steps according to the instructions:

1. With the left key of the manipulator, select an empty line, a cell in which the result of counting characters will be displayed.
2. Move the mouse cursor to the line for entering formulas at the top of the program window and write the expression: “=DLSTR(argument)». Instead of an argument, the address of a specific cell is indicated, where you need to find out the number of characters.

3. Press “Enter” when the formula is written to confirm its execution.
4. Check result. The previously specified element will display the corresponding numeric value.

Method 3: Using special sites on the Internet

You can go a more complicated way to count the number of characters in the cells of an Excel table array. It involves the following actions according to the algorithm:

1. In the same way, select the desired cell of the table array with LMB and move the mouse cursor to the line for entering formulas at the top of the program.
2. Now, with the same manipulator key, you need to select the contents of the cell in the input line.
3. Right-click on any area of ​​the selected expression and in the context type window click on the “Copy” option.
4. Log in to a browser on a PC and go to any site to count the number of characters.
5. Right-click on the workspace of the site and select the “Insert” option.
6. Familiarize yourself with the resulting value. After performing the above manipulations, the site will display all information about the length of the text.

Pay attention! On such sites, you can even count the number of sentences in the specified text.

Conclusion

Thus, in Excel, you can quickly find out information about the number of words in the desired cells of the table array. How to do this was described in detail above.