Hi,

I sanitized my worksheet and attached it.
So, where there is more than one numbered cell in Column E associated with the "item" in Column A (e.g., "AAAAAAAA1", "AAAAAAAA2", etc.), I would ideally like to separate the numbered items within a single cell instead of putting them in separate cells.

For example:
Currently, if there is more than one "step", it appears in separate cells - as follows:
-------------------------------------
| 1. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
-------------------------------------
| 2. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
-------------------------------------
... and so on ...

I would instead like the "steps" to appear in the same cell - as follows:
-------------------------------------
| 1. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
| 2. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
| 3. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
| 4. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
| 5. asdfasdfsadf sdfsdf asdf sdf |
| asdf asdf sda fasd fasd f sdi |
-------------------------------------

Thanks,
Mary

Attached Files

MultipleLinesWithinACellExcelWorksheetExample.xlsx (10.3 KB, 11 views)