| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| Counting different workinghour types | Excel Worksheet Functions | |||
| Counting the number of Error Types | Excel Worksheet Functions | |||
| Mixed data types in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
