Convert selected cells from sheet to formatted text file.

[qolio]

OK so what I want to do is select certain cells from a spreadsheet and save them as a formatted text file. By formatted, I mean that some of the cells should be joined together (concatenated?) into a string, while other cells should have a simple line break after them and if there are null values, these should be ignored. This last because the amount of data in the sheet will not always be the same from example to example.

I know I can us the concatenate function to make a string of the sort that I want so thats not a problem, its the line breaks and ignoring null values that I need answers on.

Anyone got any ideas how I might do this? Please if you do, keep it simple because I need ste by step instructions (just stupid I guess )
_________________
They always say time changes things, but you actually have to change them yourself.
Andy Warhol

[squenson]

qolio,

I am not sure that I understand what you mean by a line break. If you want to insert a Ctrl-Alt-Enter in a cell, I don't know whether it is possible with a formula. What you can do is add to a cell the Enter character with CHAR(13). It will not be visible on the screen, but if you copy/paste that cell in a text editor, a blank line will be inserted.

If you want to ignore blank cells, you can use the function: =IF(ISBLANK(A1;...;...)

If it does not help, please give me more information. You can even post a sample of what you want to achieve at http://www.mediafire.com (free, no registration required) and post the link to this forum so we can have a look at the file.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<