Afternoon

I have a data set (50K+) with various product codes such as 618B TPR, 618B
PGR, 13 VCR etc.

Firstly I want to complete a count exercise using the above codes to see how
often they match themselves within a description of the item. I somehow
need to use wild cards because it will be impossible to trim the description
down to just the production code. Happy for the solution to work on 80% of
the data.

Where it is a 1:1 match I will then aling these data records with each using
a vlookup function.

Thanks