Ask Your Question

File name link concatenation

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

jamesb gravatar image

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


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

1 Answer

Sort by » oldest newest most voted

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

mark_t gravatar image

Use the INDIRECT function

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 98 times

Last updated: Aug 12 '16