Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
Try this small macro:
Sub rowmaker() v = ActiveCell.Value s = Split(v, Chr(10)) For i = 0 To UBound(s) ActiveCell.Offset(i + 1, 0).Value = s(i) Next End Sub Select the cell and run the macro -- Gary''s Student - gsnu200846 "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
This works very well thanks
"Gary''s Student" wrote: Try this small macro: Sub rowmaker() v = ActiveCell.Value s = Split(v, Chr(10)) For i = 0 To UBound(s) ActiveCell.Offset(i + 1, 0).Value = s(i) Next End Sub Select the cell and run the macro -- Gary''s Student - gsnu200846 "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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to rows
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Rows | Excel Discussion (Misc queries) | |||
Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
text to rows? | Excel Discussion (Misc queries) | |||
Text to rows? | Excel Discussion (Misc queries) | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |