Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parse cells with line breaks
I have a spreadheet with multiple columns of data and some with line
break characters within the cells. I have an identifier in the left column, A, and the cells with line breaks inside to the right. For example, ID Books 1 The Hobbit Driving Miss Daisy 2 Only One book 3 4 First Book for id 4 Second book for id 4 Third book for id 4 I need to move this information to another sheet such that the ID is repeated for each item in the books column. The number of rows per ID would equal the number of line breaks + 1. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing line breaks into separate cells | Excel Discussion (Misc queries) | |||
how do I remove line breaks from several cells? | Excel Discussion (Misc queries) | |||
Line Breaks in cells - Mac OS X Leopard | Excel Discussion (Misc queries) | |||
Line breaks in my cells... | Excel Discussion (Misc queries) | |||
Programming Line Breaks into Cells | Excel Programming |