Thanks for the info Yashgvt, its a toughy and I didnt think there was a nice easy way to do this. The problem is I have heaps of cells that need doing and I cant spend the time doing them manually.
If there is no exact way I might go back to the start and work out a way not to have to use line breaks and instead just use whole cells for differing points of info.

Is there anyway we can suggest to Microsoft that for their next...

Hi all,
I have no clue how to slove this problem & am desperate for an answer:

I'm creating a spreadsheet and need to now how to seperate data within a single cell into multiple cells.

The info is currently stored in a single cell using line breaks and I want to seperate the info in each line break into specific cells.

Example:

red
blue
green

(above...