how to write text formula which involves multiple txt variables

[jrtaylor]

I'm working on massive 301 redirect project. My site was translated into over 50 languages, each page of each language cached in the search engines.

Now that i have revised the site I'm getting lots of 404's which is not good for SEO.

So here's the challenge:

The "bad" URL will look something like this:

I want to redirect to

Other variations of "bad" urls might look like this:

What I need to do is search for the language and create a new, concatenated cell which will begin each new url with the appropriate language.

Can someone assist me with a formula? I've attached a workbook with examples.

Thanks.