Can't process the result of CONCATENATE as a formula

asked 2015-12-23 00:34:35 +0200

Unkuiri gravatar image

Hi to all, I'm using calc on Linux and I'm trying to join various columns to make a path to a cell in another document. For that I'm using CONCATENATE() function but the result of that function is not processed as a formula.

example: In A1: file:///home/user/Dropbox/ In A2: 2016/1/ In A3: test.ods' In A4: =CONCATENATE("='";A1;A2;A3;"#$'";"sheet1'.E4"

the result in A4 is: ='file:///home/unkuiri/Dropbox/2016/1/test.ods'#$'sheet1'.E4

Is there any way to process this result as a formula and give the result of E4?

Thanks in advance

edit retag flag offensive close merge delete



May be =INDIRECT(CONCATENATE(A1;A2;A3;"#$'";"sheet1'.E4)")) ?

JohnSUN gravatar imageJohnSUN ( 2015-12-23 15:20:20 +0200 )edit