First of all, thanks for this thread, it is proving useful to me even years after the original post.

I am working on something similar, but I want the trimmed values from column B to be inserted into a plain text content control instead of in the Value field of the drop down list. I have been trying to reference the title of the plain text control and assign the trimmed value to it, but to no avail. How can this be achieved?