Insert Text From Different Cell
 

I would like to enter a company name, such as "ABC Co" in a cell on
sheet1 and then on sheet2 have a cell with text "Proposal for ABC Co".
I would also like to be wildly rich. Can anyone help with either of
those?


--
Joradi
------------------------------------------------------------------------
Joradi's Profile: http://www.excelforum.com/member.php...o&userid=26864
View this thread: http://www.excelforum.com/showthread...hreadid=401055

Lets say you manually enter in Sheet1, cell A1
ABC Co

In sheet2, cell A1, enter
="Proposal for " & Sheet1!A1


Mangesh




"Joradi" wrote in
message ...

I would like to enter a company name, such as "ABC Co" in a cell on
sheet1 and then on sheet2 have a cell with text "Proposal for ABC Co".
I would also like to be wildly rich. Can anyone help with either of
those?


--
Joradi
------------------------------------------------------------------------
Joradi's Profile:
http://www.excelforum.com/member.php...o&userid=26864
View this thread: http://www.excelforum.com/showthread...hreadid=401055

On Sheet1 in Cell A2 Type: ABC Co

On Sheet2 in Cell A2 Type this formula: ="Proposal for" & " "
&TEXT(Sheet1!A2,"a")

The first part: *="Proposal for"* is just the first bit of text

The Next Part: *& " "* makes sure there is a space between the first
bit of text and the next on sheet1

The final part: *&TEXT(Sheet1!A2,"a") * takes the value of the cell A2
on sheet1 and makes the format text.

Hope this helps

Dave


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=401055

Thank you Mangesh and Dave. I greatly appreciate your help. If you have
any ideas on the "get wildly rich" problem, please let me know about
that as well.

Thanks Again!


--
Joradi
------------------------------------------------------------------------
Joradi's Profile: http://www.excelforum.com/member.php...o&userid=26864
View this thread: http://www.excelforum.com/showthread...hreadid=401055