 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Adding one line full of text / variables / formulas
Is there any way in Excel to have one field that outputs something like this The configuration you chose was "=A1". It has "=B5" hard drives totalling "=B5*750" TB of data storage. I am looking for excel to dynamically replace what is in quotes with the field / result of the calculation. I didn't wan't to do separate cells, so that the spacing was right. > Is there any way in Excel to have one field that outputs something like > this [quoted text clipped - 5 lines] > field / result of the calculation. I didn't wan't to do separate cells, > so that the spacing was right. Does putting this in your output cell do what you want? ="The configuration you chose was "&A1&". It has "&B5&" hard drives totalling "&B5*750&" TB of data storage." Rick Perfect. Thank you both very much. >> Is there any way in Excel to have one field that outputs something like >> this [quoted text clipped - 12 lines] > > Rick >Is there any way in Excel to have one field that outputs something like this > [quoted text clipped - 4 lines] >field / result of the calculation. I didn't wan't to do separate cells, so >that the spacing was right. ="The configuration you chose was & A1&". It has " & B5 &" hard drives totalling >" & B5*750 & " TB of data storage." --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.