On Wed, 15 May 2013 13:37:37 +0100, aikhalif wrote:


Ron,
SM co indicates the short version of Sports Metrics, considering the
first letters S and M.

As for ex, i just want an example where there are dummy variables before
the word and variables after that are consiedered and matched.

Thanks.

Oh, it is easy to see what you want to do.

The problem with doing it using a formula (or a UDF) is that there does not seem to be a logical rule that will apply to all instances. The issue with SM co is only one of several problems in what you present.
In the absence of rules (and examples, such as you have presented, are NOT logical rules), it is not possible to devise a formula that will cover all the variability that you have presented.

I would suggest since you cannot create logical rules, for you to create a lookup table (or manually clean up your original data).