Text to rows
Excellent thank you!
"Gord Dibben" wrote:
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?
|