Ask Your Question

File name link concatenation [closed]

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

jamesb gravatar image

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


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


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:




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:


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

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

mark_t gravatar image

Use the INDIRECT function

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 177 times

Last updated: Aug 12 '16