Pretty much every arts administrator knows the pain of looking at a long list of content in a Microsoft Word document where each line is separated by a paragraph, but you need them separated by line breaks. You could go through and manually change each…and…every…one or you can use this Find and Replace trick to do the entire doc in seconds.
- Use CTRL + H to bring up the Find and Replace dialog box and in the Find whatfield enter ^p (the upward arrow character is a caret and is usually available on the “6” number key).
- In the Replace with field enter ^l (the caret character and lower case “L”).
- Select Replace All and watch the magic!
- Your paragraph list is now a tidy line break list.
Swap ^p and ^l if you need to convert a line break list into paragraphs.
If you work with data import, you’re probably well acquainted with comma separated lists, the life blood of field import formats in most database platforms. You can use a similar trick to convert a long list of paragraph or line separated names.
- Use CTRL + H to bring up the Find and Replace dialog box and in the Find whatfield enter ^p (or ^l if the source list is line separated).
- In the Replace with field enter , (be sure there are no errant spaces in the mix).
- Select Replace All and you have a near perfect comma separated list.
- I say near perfect because there may have been an extra paragraph/line break at the end of the list and if so, the process will convert that to a comma as well. If so, be sure to manually remove it before using the list for the forces of comma separated list goodness.