View Single Post
  #1   Report Post  
Althea
 
Posts: n/a
Default 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