Input the text of a cell into a text only cell - text formul

[cjones88]

Hi. I'm new to the board and thought I knew a lot about excel, only to find out I'm a mere beginner.

I have a cell, we'll call it A1 that has the text "John Doe" in it. I have another cell in my sheet that has the text "_____'s Annual Costs". I want the blank to be the contents of cell A1 so whenever I change A1, it automatically updates the other cell. Basically this is a text formula. Is there a way to do this? I've been trying for months. Thanks.

 

[tk19]

= Sheet1!A1 & "'s Annual Costs"

 

[cjones88]

Perfect. Thanks for the help. I knew it had to be something simple.

 

[IML]

Just in case this for english class, you could use
=PROPER(A1)&IF(RIGHT(A1)="s","' Annual Costs","'s Annual Costs")