| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
