Hi all, I have a lot of text documents to copy into Libre Calc sheets. I can’t do regular file import because there is other stuff in the sheet as well. I would like to have either each cell call numbers from the text document, or import the file into a certain cell range/area of the sheet.
I don’t want to just copy/paste the text files because this gets very time consuming when there are a lot of them!
Is there an automated function for this or a command-method to do this? If not, is there a way to write a script that would get the files? Would some kind of macro work? The text files are all organised into columns by being tab or space delimited.
Thank you all very much for the help!!