Getting rid of new line command between 2 sets of info
 

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

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

Wow, Many thanks
Works perfectly
"Peo Sjoblom" wrote in message
...
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

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