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