Hi Nick,

After reading your question 3 times, I'm still confused on what you want. How about a sample worksheet showing it. The problem doesn't sound that hard, if understood. Are you looking for an Indirect command or do you want to append the uppercase text at the end of some other text.