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

--
Regards,

Peo Sjoblom


"Althea" wrote in message
...
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