Received a ZIP file, opened and storted in My Docments. The file opened as a OpenOffice 1.1 text doc, 3K+.
I know the data is a series of about 15 columns.
I cannot figure out how to import it into Calc and make it structure into the appropriate columns.
When I go to Open in Calc and select the file I get a window re info re the tabs and other data, but see no way to set ‘delimited’ as the format. As a result when I select Open in that window each line of the data set is in closed string with all the separaters, not under a set of columns. I am not a frequent user of Calc so am stymied. Suggestions please on how I convert this text file to a spreadsheet format.
First select an appropriate file type, then open the file. From your description, it might be a CSV file. To advise further, share a sample.