Adding one line full of text / variables / formulas

's Computer Specifications

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.

's Computer Specifications

> 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.

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

's Computer Specifications

On Fri, 17 Aug 2007 14:03:15 -0400, "Jon Arbuckle" <(E-Mail Removed)> wrote:

>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.
>

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

's Computer Specifications

Perfect.

Thank you both very much.

"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>> 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.
>
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Working with AutoShapes - Adding Text Vs Adding Formulas	JeffTO	Microsoft Excel Programming	1	30th Jul 2009 07:18 PM
Can't use full space of line for text	pablobandito	Microsoft Powerpoint	1	14th Mar 2008 05:08 PM
Reports - Formating a line of text with variables	The Boondock Saint	Microsoft Access	2	16th Dec 2005 03:37 AM
Adding text in formulas	=?Utf-8?B?QW5kcmVhcw==?=	Microsoft Excel Worksheet Functions	2	11th Jul 2005 12:07 PM
Re: Adding text to formulas	Tony	Microsoft Excel Misc	0	9th Aug 2003 04:53 PM