Excel Forum
Similar Content
Split Text into Multiple Cells in Excel
Tutorial: How to split text from one cell into multiple cells quickly and easily in Excel.  This in...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel
Tutorial: This allows you to make sure that there are no hidden spaces at the start or end of the te...

Excel Magic Trick 290: Count Codes From Column of Text Strings

See how to count codes from a column of text strings that hah multiple codes. For example: If we are counting PCP in this list: {"PCP, TP, N, N, PA";"N, N, PA";"PCP, N, PA";"TP, N, NP"} we would want to get 2.
See a formula that counts that uses the SUMPRODUCT, LEN and SUBSTITUTE functions.
LEN & SUBSTITUTE functions Counting Tricks

Got a Question? Ask it Here in the Forum.