| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a separate cell entry for every individual line in a cell
You can break these into separate cells across a row using DataText to
ColumnsDe-limited byOtherAlt + 0010(on the numpad) Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 05:31:13 -0700, DaveyC4S wrote: Hi I have a lot of cells of data with free text in them. In order to use this data I need to create a separate cell for every line of text within a cell. The lines have been defined in the original cells using the Alt-Enter function. Does anyone have an idea of how to tackle this? Any help much appreciated David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Can you enter a new line in an individual cell within Excel | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| How do I separate worksheets in a workbook into individual files? | Excel Worksheet Functions | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
