doctoring line breaks in and out of a .csv

I have found a ways to remove all line breaks in a .csv file and then add my own back in. This is really helpful if the .csv was made from other data just copied into Notepad (say from XML). First step: copy to Word. To remove all line breaks in word:

1. do a find and replace replacing ^p^p with ^l (lowercase L)
2. do a find and replace replacing ^p with nothing

 
 

To add line breaks back in to define the rows in a .csv. Do this find and replace in Word and then copy back to Notepad:

1. do a find and replace replacing what you will with ^p