How to Count the Number of Words in a Column in Excel 2007

Save

Whether you have a word count restriction for your spreadsheet or are simply curious about the word count in a particular column, Excel 2007 allows users to find the number of words with a predetermined formula. Excel formulas are created to adjust to any data that is modified. For example, if you change a value in cell A5 and the formula in cell B6 is linked to cell A5, the value of cell B6 will change. By knowing the word count formula, you can calculate the number of words within a given column and rows.

  • Identify the column and amount of rows you wish to count the words. For example, if you wish to calculate the amount of words in column B from rows 3 to 15, write down "B3" and "B15" for future reference.

  • Double-click in the cell where you want the word count value to appear.

  • Enter the formula inside the cell. Using the example column from Step 1, the formula looks like this:

    =SUM(IF(LEN(TRIM(B3:B14))=0,0,LEN(TRIM(B3:B15))-LEN(SUBSTITUTE(B3:B15," ",""))+1))

    Replace "B3:B14" with the range of rows from your column.

  • Press the "Enter" key on your keyboard to calculate the number of words within the column range. The formula is replaced by a numerical value that represents the word count. If you wish to modify the formula, left-click the cell once and modify it through the textbar above the spreadsheet column labels.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!