Text data - formulas
 

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!

Text data - formulas
 

=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!

Text data - formulas
 

To add to Peo, if the "word" is not the only text in the cell, but may be
combined with other words, include the wildcard in the search:

=COUNTIF(A1:A1000,"*word*")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Peo Sjoblom" wrote in message
...
=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!