Insert Text From Different Cell

  • Thread starter Thread starter Joradi
  • Start date Start date
J

Joradi

I would like to enter a company name, such as "ABC Co" in a cell o
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 o
those
 
Lets say you manually enter in Sheet1, cell A1
ABC Co

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


Mangesh
 
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
 
Thank you Mangesh and Dave. I greatly appreciate your help. If you hav
any ideas on the "get wildly rich" problem, please let me know abou
that as well.

Thanks Again
 
Back
Top