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.

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jul 13, 2010 at 07:01 AM
try this

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

note the asterisk signs.
0
Hi Venkat1926,

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