Ask Your Question
0

File name link concatenation

asked 2016-08-12 01:10:50 +0200

jamesb gravatar image

updated 2016-08-12 01:24:31 +0200

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-12 01:23:37 +0200

mark_t gravatar image

Use the INDIRECT function

=INDIRECT(CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1)))
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-12 01:10:50 +0200

Seen: 98 times

Last updated: Aug 12 '16