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

A1	APPLES BANANAS GRAPES
A2	ORANGES MANGOS

<tbody>
</tbody>

A1	APPLES
A2	BANANAS
A3	GRAPES
A4	ORANGES
A5	MANGOS

<tbody>
</tbody>

 

[shg]

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