Hi all,

Let me first say that you all have saved my bacon more than once, with your great advice and know-how. Thank you! I'm in your debt.

This time around, I'm trying to edit the contents of each cell in column F on the basis of the contents in same row of column C. Specifically, if the cell in column C reads either "German" or "Korean," I want to add the text "Certified translation of " to the beginning of the string in the same row of Column F.

I'm not sure if this is easiest to do with VBA or with a formula, so I thought I'd ask here first.

Thank you!

Rob