Removing char(10) only from the end of data in one cell

Hi!
I have to combine data from 10 cells into one cell, so that each data is displayed in a new row inside that cell. I have combined them with "=A1&char(10)&A2&char(10)&A3...".
The problem is that not all rows have the same amount of data in the combined cell and I got some very big cells with one or two data and many new line signs at the end.

I've tried to copy values and define that inside the cell the text is wraped, but not all data are the same length, and it is impossible to adjust the column for all cells to display in the right manner.
The TRIM function removes all the char(10), and I don't want to remove them all.
Tried to insert
=A1&if(A2><0;char(10);"")&if(A2><0;A2;"")&.... and
=A1&if(A2><" ";char(10);"")&if(A2><" ";A2;"")&.... but got the same result.

Any suggestions how to resolve this problem, or do it in another way would be very appreciated

Thank you very much for your help.

Thank you...I know that char(10) is Alt+Enter. I don't want to do it in every cell manually.

Maybe I haven't explained it well. If it was a matter of one cell I would do it manually .

My data looks like that in the picture. In the right column is shown the content of the cell without wrapping.
I want to delete the little squares that are at the end in most of the cells, and to autoformat the size of the cell depending of the amount of real data inside of it. I hope that this clears what I'm asking.

noname.gif

I have resolved it!
The correct formula looks like this and leaves just one new line at the end of all data. I can live with that!

Please Login or Register  to view this content.