View Single Post
 
Old 12-11-2014, 01:55 PM
mtcn mtcn is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2014
Posts: 7
mtcn is on a distinguished road
Default

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
File Type: xlsx MultipleLinesWithinACellExcelWorksheetExample.xlsx (10.3 KB, 11 views)
Reply With Quote