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
|