I have various text documents that I've pasted within Excel.

On some occasions the entire document fits inside a single cell, in other cases the document overlaps several rows (dividing each sentence to its own row/cell )
I understand its a formatting issue, however I'm trying to duplicate this within excel.


If I type a large body of text( a few paragraphs of common sentences) within a single cell and paste this into another cell. How can I format this such that it fills into the lower rows (ie: a new row per sentence)


Thanks for any help

~Jeff