If I'm in cell C5, I want a formula that will do the following; if cell B5
contains "Assembly" anywhere in it's text, then I want C5 to say Assembly,
otherwise I want C5 to copy B5.

Any help?