Copying a word from one cell in a different worksheet into the middle of a sentence.

Hi All,

I have a problem with how to do the above. I have cell A1 which for example might say 'Danny' in worksheet one. In worksheet 2 cell A1 has 'fine'. I would like to then write a sentence in Worksheet 2 cell A2 that says. Danny's health is fine. The way I thought it should be written is as below.

Please Login or Register  to view this content.

but of course this doesn't work. Is this because it can only include one other cell? Can anyone help please?

Thanks

Danny

Thank you very much . Just had the & in the wrong place. I had assumed it goes before the cell reference but common sense says it goes after if the cell reference comes at the start of the sentence.

Reputation and thread name done

Regards

Danny