Concatenate Strings And Values To Create Formula
I am using Excel 2013.
Cell AL7 has the value 7 in it.
I have created the following formula in P7:
=concatenate("=","A",AL7)
The hope was that this would produce in P7 a formula (i.e. =A7).
Instead it creates a string, i.e. "=A7".
Is it possible to create an Excel formula by concatenating strings and
values?
Thanks.
--
tb
|