Cranberries
New Member
- Joined
- Oct 11, 2006
- Messages
- 5
Hi there
I have a spreadsheet with a cell containing a few lines in one cell and I would like to split the cell into many cells ie:
Currently the cell contains 3 rows in one single cell(as Alt + Enter was used to get them all in one cell)
100
200
300
Now what I'm trying to do is split up the contents of the above cell into 3 different cells
ie
100
200
300
all on different rows.
Is the above possibe?
I have a spreadsheet with a cell containing a few lines in one cell and I would like to split the cell into many cells ie:
Currently the cell contains 3 rows in one single cell(as Alt + Enter was used to get them all in one cell)
100
200
300
Now what I'm trying to do is split up the contents of the above cell into 3 different cells
ie
100
200
300
all on different rows.
Is the above possibe?