View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wes_SA Wes_SA is offline
external usenet poster
 
Posts: 1
Default Counting word types in a cell

If the text below was contained in one cell in Excel, how do I count the
instances of say "PFD". If this can be done how do I then count for multiple
cells.


15-PR-11-PFD-001 REV.0A
15-PR-13-PFD-001 REV.0A
15-PR-17-PFD-002 REV.0A
15-PR-18-PFD-001 REV.0A
15-PR-11-PID-014 REV.0A
15-PR-11-PID-022 REV.1A
15-PR-11-PID-023 REV.1A
15-PR-17-PID-003 REV.1A
15-PR-13-PID-029 REV.1A
15-PR-11-PID-030 REV.1A