Text data - formulas

  • Thread starter Thread starter excelbeginner
  • Start date Start date
E

excelbeginner

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!
 
=COUNTIF(A1:A1000,"word")

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


--


Regards,


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

=COUNTIF(A1:A1000,"word")

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


--


Regards,


Peo Sjoblom
 
Back
Top