# Can't process the result of CONCATENATE as a formula

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?

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