Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Open the TXT file from calc, on the import dialog disable all separators, a new spreadsheet should open with a line by row.
Copy the first cell of this file in the destination file, using past special [Shift+Ctrl+V], mark link and Ok. A link to the first cell in the TXT should be there, now you can close the TXT file and copy and past or drag the formula down.
This can be done with a large range of TXT file, a matrix link with the range it's pasted. Play a bit to find your way.