Excel: copy the content variable in the formula


A B
1 AAPL MSFT
2 ='C:\Documents and Settings\SASTC\My Documents\Stock Data\[AAPL.csv]AAPL'!E2 ='C:\Documents and Settings\SASTC\My Documents\Stock Data\[MSFT.csv]MSFT'!E2
how should i COPY automatically "XYL" written as in formula (XYL.csv and XYL') comprehending with the top bar? Tried "&C1&" but it`s not working.:banghead:


This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of October 08, 2013.


For more resources for Microsoft Excel