Text formatting: from single cell to numerous cells

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

If you are copying from one cell to another cell within Excel, it will always paste 1:1 and will not transfer to multiple cells. Sorry

ChemistB

Try copying into word, and then converting to table using full stops as paragraph markers, then copy all back into Excel.

you could also use LEN to count all the characters in the cell, (assume 197)and then SEARCH for the first full stop. Assume it is at char 43. Left (cellref,43) gives you the first sentence, right (cellref,154) gives you the remaining sentences. Now look for the nect fullstop, and so on