Spacing multiple variable paragraphs in a merged cell

Hello everyone!

Many thanks for pointing out the forum rules to me previously.

Although I have picked up a lot with excel over the last couple of years, I have come across a problem that I need to address and am therefore looking for some help.

I am using excel as a base for formatting reports, and collating logical paragraphs, which I want to display in one massive merged cell on another worksheet.

The paragraphs are different for each report, and I do not wish to manually enter them in each time. I also want them to display as seperate paragraphs on the page, but in the same cell.

To throw a spanner in the works, the paragraphs are all of indeterminate length, otherwise, I could use different cells.
If I combine them in the massive merged cell by using =cell1&cell2&cell3 then they will just appear merged as one whole huge paragraph.
I want them to appear as separate paragraphs in the same big cell.

Try doing

Please Login or Register  to view this content.

CHAR(10) is Line Feed or Carraige Return (I never remember)

Hope that helps...
John

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

On an aside, JB had posted a possible solution on your other thread but I'm afraid we're fairly stringent re: titles to aid "search" facilities as such his reply was hidden with the expectation that you would revise your thread title as requested, however, you opted rather to create a new thread entirely so unfortunately JB's help was not acknowledged.... going forward if possible please action Mod requests in the thread in which they occur.

TIA for your co-operation.