=COUNTIF(A1:A1000,"word")

replace A1:A1000 with your range and word with the word you want to count


--


Regards,


Peo Sjoblom





"excelbeginner" wrote in message
...
I am entering text data into a spreadsheet and I need to know how to
calculate the number of times particular words/phrases appear in each
column.
I am very new to excel, so any help would be appreciated!