Extract a specific word from cells and count [Solved/Closed]

Report
-
 Allen Des -
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.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
try this

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

note the asterisk signs.
Hi Venkat1926,

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