Thanks for this but becasue there is a forced line break there is no way I
can specify a separator unless I am misunderstanding what to do.

"Luke M" wrote:

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?