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

Hi XUT67,

One answer I believe your looking for is:

=CONCATENATE("The ",B1," only costs ",C1,". Order today, we only have
",D1," left!.")


Hope that helps.


--
Marcster

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.
To get the dollars to show up with the $ use this:
="The " & B1 &" cost only " & DOLLAR(C1,2) & ". Order today, we have
only " & D1 & " left!."
Grammatically correct also. I minored in English!
Bob


--
jahoobob