# Revision history [back]

Hello

Using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22  However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this: =CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))


Where the value in cell A1 is "22".

Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell:

'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22  The method is eluding me, despite much searching. I'd be most grateful if someone could help. Thank you. ### File name link concatenation Hello Using In Calc, using the following I can, of course, call in data into my current spreadsheet file: ='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22


However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this:

=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))  Where the value in cell A1 is "22". Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell: 'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22


The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.

Hello

In Calc, using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22  However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this: =CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))


or

=CONCAT("=","'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))  Where the value in cell A1 is "22". Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell: 'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22


The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.