Previous Topic Next Topic

Extract a specific word from cells and count

Solved/Closed
Allen Des - Jul 13, 2010 at 01:47 AM
 Allen Des - Jul 13, 2010 at 07:35 AM
Hello,



I want to find the formula in Excel 2003 to be able to extract a specific word from a cell and count the number of instances this word come up and provide the sum of times of this word being listed.

For example: I want to count the number of times the word 'SAP' or 'sap' appears and the following:

sap a ss
sap iuoa
sap
sap tey
hello sap
sap works

-----------------------------------------

The result should give me '6' in a cell.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 13, 2010 at 07:01 AM
try this

=COUNTIF(A1:A6,"*sap*")

note the asterisk signs.
0
Allen Des
Jul 13, 2010 at 07:35 AM
Hi Venkat1926,

Worked like a charm. Thank you for providing me this solution!
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response