I have a spread sheet in which in one of the columns the cells contain (maybe several) strings of the form 11C23, 05C15, 46B21. ( They are all of the form [0-9][0-9][A-Z][0-9][0-9], and are separated by spaces or commas. )

Of the possible 260000 codes only about 200 of them occur.

I would like first, to get a list of the strings that occur, and then count the number of times each such string occurs.

I can count the number of times a particular string occurs with

```
=SUMPRODUCT(ISNUMBER(FIND(C2, $B$2:$B$464)))
```

where my string is in C2, so, I guess, if I could get these individual strings into column C, I could copy this command into each row. But how would I get a list of these strings.

Any help would be appreciated.