To split at the forced line break in delimited byother hold the Alt key and
type 0010 on the numpad.


Gord Dibben MS Excel MVP

On Thu, 16 Apr 2009 06:56:11 -0700, Phippsy
wrote:

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?