Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put text and a cell reference in a text box?
Hello
I would like to put the following in a text box in an Excel worksheet (version 2003): The funding requirement for the Project is US$650m, which consists of US$450m of senior debt, subordinated debt of US$100m and equity of US$100m. I would also like the text box to source the numbers above from cells in the the same Excel worksheet, so that the figures are automatically updated and I don't have to go in and manually change the numbers every time there is an update. I know how to put only a cell reference in the text box, but how do I include the text too? Any thoughts would be most welcome. Sarah |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put text and a cell reference in a text box?
Use a Textbox from the Drawing toolbar.
Select the textbox and in the formula bar enter "=B5" In B5 enter "=G5 & G6 & G7" In G5 to G7 enter the text and numbers to appear in the textbox. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sarah Lefevre" wrote in message Hello I would like to put the following in a text box in an Excel worksheet (version 2003): The funding requirement for the Project is US$650m, which consists of US$450m of senior debt, subordinated debt of US$100m and equity of US$100m. I would also like the text box to source the numbers above from cells in the the same Excel worksheet, so that the figures are automatically updated and I don't have to go in and manually change the numbers every time there is an update. I know how to put only a cell reference in the text box, but how do I include the text too? Any thoughts would be most welcome. Sarah |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put text and a cell reference in a text box?
It's not very elegant, but the following concatenation will work.
=CONCATENATE("The funding requirement for the Project is US$"&C30&"m, which consists of US$"&E30&" of senior debt, subordinated debt of US$"&G30&"m and equity of US$"&I30&"m") In this example, I used cells C30, E30, G30, and I30 as the cells that held the various values you want to automatically update. Obviously you'd have to replace the cell references with your own references, but it will work. MM "Sarah Lefevre" wrote: Hello I would like to put the following in a text box in an Excel worksheet (version 2003) The funding requirement for the Project is US$650m, which consists of US$450m of senior debt, subordinated debt of US$100m and equity of US$100m. I would also like the text box to source the numbers above from cells in the the same Excel worksheet, so that the figures are automatically updated and I don't have to go in and manually change the numbers every time there is an update. I know how to put only a cell reference in the text box, but how do I include the text too? Any thoughts would be most welcome. Sarah |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put text and a cell reference in a text box?
Using CONCATENATE you don't need the ampersand (&) in it, substitute commas
where there are currently ampersands. You could do it without the CONCATENATE() just the way you have it written using the ampersands and results would be the same. =CONCATENATE("The funding requirement for the Project is US$",C30,"m, which consists of US$",E30," of senior debt, subordinated debt of US$",G30,"m and equity of US$",I30,"m") gives same result as ="The funding requirement for the Project is US$"&C30&"m, which consists of US$"&E30&" of senior debt, subordinated debt of US$"&G30&"m and equity of US$"&I30&"m" "mmcdonald1@msn" wrote: It's not very elegant, but the following concatenation will work. =CONCATENATE("The funding requirement for the Project is US$"&C30&"m, which consists of US$"&E30&" of senior debt, subordinated debt of US$"&G30&"m and equity of US$"&I30&"m") In this example, I used cells C30, E30, G30, and I30 as the cells that held the various values you want to automatically update. Obviously you'd have to replace the cell references with your own references, but it will work. MM "Sarah Lefevre" wrote: Hello I would like to put the following in a text box in an Excel worksheet (version 2003) The funding requirement for the Project is US$650m, which consists of US$450m of senior debt, subordinated debt of US$100m and equity of US$100m. I would also like the text box to source the numbers above from cells in the the same Excel worksheet, so that the figures are automatically updated and I don't have to go in and manually change the numbers every time there is an update. I know how to put only a cell reference in the text box, but how do I include the text too? Any thoughts would be most welcome. Sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Text Cell to Reference a Worksheet Name | Excel Worksheet Functions | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
text color change in cell reference | Excel Discussion (Misc queries) |