| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| How do I print all the text in a cell | Excel Discussion (Misc queries) | |||
| Link the value to text in a cell, then use that text cell in a for | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
