Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Word

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.
See more

1 reply

Answer 1 / 1
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.
Report

Hi Venkat1926,

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