Adding one line full of text / variables / formulas

  • Thread starter Thread starter Jon Arbuckle
  • Start date Start date
J

Jon Arbuckle

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

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.
Click to expand...

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
 
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.
Click to expand...

="The configuration you chose was & A1&". It has " & B5 &" hard drives
totalling >" & B5*750 & " TB of data storage."
--ron
 
Perfect.

Thank you both very much.

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top