Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text join formulas working but act as straight text when modified | New Users to Excel | |||
formulas with text | New Users to Excel | |||
text formulas | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Parsing Data with Formulas (vs Text-to-Columns) | Excel Worksheet Functions |