Ask Your Question
0

File name link concatenation [closed]

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

jamesb gravatar image

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 14:34:05.237309

1 Answer

Sort by » oldest newest most voted
0

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

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

Question Tools

1 follower

Stats

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

Seen: 177 times

Last updated: Aug 12 '16