How Can I accomplish this, say this is field A1:

The %product% only costs %price%. Order today, we only have %qty%
left!

--------------
Obvoiusly the words enclosed in % % are the variables that I want
replaced.
Is there way that I can make fields B, C, and D equal the corresponding
variables?

For example,

B1= Dog collar
C1= $9.99
D1= 20

So then A1 becomes:

The dog collar only costs $9.99. Order today, we only have 20 left!

I'm open to trying ANY method that can allow me to use variables in
Excel.

Thanks.


--
XUT67

You could name each cell:
Insert|Name|define

I named B1: Product
C1: Price
D1: Qty

Then I put this in A1:

="The " & Product & " only costs "
& TEXT(Price,"$0.00") & " Order today, we only have "
& TEXT(Qty,"#,##0") & "left!"

(all one cell)

XUT67 wrote:

How Can I accomplish this, say this is field A1:

The %product% only costs %price%. Order today, we only have %qty%
left!

--------------
Obvoiusly the words enclosed in % % are the variables that I want
replaced.
Is there way that I can make fields B, C, and D equal the corresponding
variables?

For example,

B1= Dog collar
C1= $9.99
D1= 20

So then A1 becomes:

The dog collar only costs $9.99. Order today, we only have 20 left!

I'm open to trying ANY method that can allow me to use variables in
Excel.

Thanks.

--
XUT67

--

Dave Peterson