May be Explode is the correct to do this!
Rui de Oliveira wrote:
I have 4 cellīs
1= colun
2 = line
3 = sheet
4 = result
I dont know if is possible, but i fink tha is...
I neet to do some thing like this in the cell results;
(join the cell nš)=CONCATENATE(colun;line)
(sheet name) =test
Make like =CONCATENATE("'";sheetname;"'";"!";join)
now i fink I have someting like this [ ='standard'!D28 ]
Now, i need to make a formula off that, and only I can do is see the
information on the cell
Can some 1 Help me????
Thanks a lote!!!!!!!!
You have to use the INDIRECT function also...
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|