Reply to thread

Message

<blockquote data-quote="doveman" data-source="post: 823397" data-attributes="member: 67412">Yeah, thanks that does get me started. I don't actually have Word, just Open Office (and LibreOffice although I've not tried that yet) but it does have a similar Convert text to table function which lets me use the ( as separator.I will have to manually sort out the mixture of format and runtime in the third column. What would really help is a &quot;Swap cell x and x&quot; function, which I could use on the entries which have the format in cell 2 and runtime in cell 3, but I'm not sure there is such a function.Hmm, I'm not sure OpenOffice can convert back to text and insert , between the fields. It has a Convert Table to Text option but that doesn't let me specify a separator.If I can't find a way, I can always take it round somewhere that does have Word and do it there.EDIT: I've managed to do it by pasting the data into Open Office spreadsheet and exporting as a CSV from there <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="doveman, post: 823397, member: 67412"] Yeah, thanks that does get me started. I don't actually have Word, just Open Office (and LibreOffice although I've not tried that yet) but it does have a similar Convert text to table function which lets me use the ( as separator. I will have to manually sort out the mixture of format and runtime in the third column. What would really help is a "Swap cell x and x" function, which I could use on the entries which have the format in cell 2 and runtime in cell 3, but I'm not sure there is such a function. Hmm, I'm not sure OpenOffice can convert back to text and insert , between the fields. It has a Convert Table to Text option but that doesn't let me specify a separator. If I can't find a way, I can always take it round somewhere that does have Word and do it there. EDIT: I've managed to do it by pasting the data into Open Office spreadsheet and exporting as a CSV from there :) [/QUOTE]

Verification