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

cjones88 · Mar 15th, 2002, 12:33 PM

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 · Mar 15th, 2002, 12:42 PM

= Sheet1!A1 & "'s Annual Costs"

cjones88 · Mar 15th, 2002, 12:50 PM

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

IML · Mar 15th, 2002, 12:56 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 12:33 PM	#1
cjones88 New Member Join Date: Mar 2002 Location: Atlanta Posts: 23	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.

Mar 15th, 2002, 12:42 PM	#2
tk19 New Member Join Date: Mar 2002 Posts: 33	= Sheet1!A1 & "'s Annual Costs"

Mar 15th, 2002, 12:50 PM	#3
cjones88 New Member Join Date: Mar 2002 Location: Atlanta Posts: 23	Perfect. Thanks for the help. I knew it had to be something simple.

Mar 15th, 2002, 12:56 PM	#4
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	Just in case this for english class, you could use =PROPER(A1)&IF(RIGHT(A1)="s","' Annual Costs","'s Annual Costs")