Move to new cell.

[Nanogirl21]

I have cells that have multiple lines of data that is seperated by a return. Is there any way to break these returns into their own cells?

EXAMPLE:

CURRENT
[TABLE="width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]APPLES
BANANAS
GRAPES
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]ORANGES
MANGOS
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]APPLES
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]BANANAS
[/TD]
[/TR]
[TR]
[TD]A3
[/TD]
[TD]GRAPES
[/TD]
[/TR]
[TR]
[TD]A4
[/TD]
[TD]ORANGES
[/TD]
[/TR]
[TR]
[TD]A5
[/TD]
[TD]MANGOS
[/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

Select the column, Data > Text to column, tick Delimited, press Next, tick Other, and in the box Ctrl+J, press Finish