Multi Line Cell Spliting

[SamLPC]

Hi,

I have a file with approx 900 rows and 8 columns, in one and only one of the columns each row contains muliple lines (between 3-5) i am wondering how to go about seperating each of the multiple lines and inserting each of them in a new column to the right (potentially creating 5 new columns). There are no delimiters seperating the lines and after trawling the internet, using Alt+010 or Ctrl+J within the 'text to column' part of excel does not seem work at all.

If anyone has any ideas they could share i would be really grateful!

Thank
Sam