Where is word count in excel

How to count word count in Excel: First open the table and select the working data; then select the cells that need to be counted and enter the formula [=LEN(E2]]; finally press Enter and a number will appear, and pull down to fill in the cell Just click the grid.

Excel word count counting method:

#1. Open your own EXCEL table on the computer

2. Select the working data in the table you want to operate

3. If you need to count the number of words in cell E2 , select E2 in the E sequence, as shown in the figure

4. Enter the formula "=LEN(E2)"

in the formula column of the required cell F2

5. Click the Enter key to get the word count in cell E2.

#6. If statistics are needed For the number of words in other cells in column E, just select cell F2, place the mouse on the lower right corner of the cell, and when the cross fill handle appears, pull down the mouse.

7 , you can calculate the number of words in the remaining cells in column E.

Related learning recommendations: excel basic tutorial

The above is the detailed content of Where is word count in excel. For more information, please follow other related articles on the PHP Chinese website!