concatenate
in [Functions]
|
From: rpmani on 16 Apr 2010 08:13 I want to combine three cells with 'Concatenate' function and get the result like cell A1 = 10 (emp code) cell B1 = filename.xls cell C1 = sheet1'!A1 my coding is =concatenate(a1,b1,c1) --- it should show the content of cell A1 in 10filename.xls , since the A1 is changeable. rpmani
From: Jacob Skaria on 16 Apr 2010 08:49 Try the below. (Hope 10filename.xls is open) =INDIRECT("'["&A1&B1&"]" & C1) -- Jacob (MVP - Excel) "rpmani" wrote: > I want to combine three cells with 'Concatenate' function and get the result > like > > cell A1 = 10 (emp code) > cell B1 = filename.xls > cell C1 = sheet1'!A1 > > my coding is > > =concatenate(a1,b1,c1) --- it should show the content of cell A1 in > 10filename.xls , since the A1 is changeable. > > rpmani > > > >
From: Dave Peterson on 16 Apr 2010 13:06 The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm That includes =indirect.ext() that may help you. === If you have trouble getting to the site, then search google for indirect.ext. I found this alternative site: http://download.cnet.com/Morefunc/3000-2077_4-10423159.html I didn't look to see if it was the most current version. I'd check the original site every so often to see if it's working. rpmani wrote: > > I want to combine three cells with 'Concatenate' function and get the result > like > > cell A1 = 10 (emp code) > cell B1 = filename.xls > cell C1 = sheet1'!A1 > > my coding is > > =concatenate(a1,b1,c1) --- it should show the content of cell A1 in > 10filename.xls , since the A1 is changeable. > > rpmani > -- Dave Peterson
|
Pages: 1 Prev: Sum of retuned valus as digits Next: excel 2007 macro recorded pivot table |