Easiest method is usually to use the Data-Text to columns feature, then copy,
paste special - transpose data.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phippsy" wrote:

I have text in a cell which has been forced onto separate rows within the
same cell. Can I split this into several rows so there is one line in each
new row?