Thread: [SOLVED] How do I use variables in Excel?

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