Getting rid of new line command between 2 sets of info

[Althea]

Hi List
I have a spreadsheet that has Fathers name, occupation (then I pressed Alt +
enter) to put on a new line in same cell a second Fathers name, occupation.
IS there any formula that will allow me to separate this into 2 separate
columns or at least replace the new line order with semicolon.
Many thanks
Althea

 

[Peo Sjoblom]

First make sure the next column to the right is empty, if not insert a new
column, the select the column, do data>text to columns, select delimited,
click next, click other, hold down alt while typing 010 on the numpad,
release alt, click finish

 

[Althea]

Wow, Many thanks
Works perfectly

First make sure the next column to the right is empty, if not insert a new
column, the select the column, do data>text to columns, select delimited,
click next, click other, hold down alt while typing 010 on the numpad,
release alt, click finish