View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default 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