How many times have you received a document or an eMail, you do a Copy and Paste, and find line fragments instead of paragraphs that you can Word Wrap or easily read in you word processor of choice .
Well here's a way that I use to format a block of text so that it becomes a bit more readable (naturally, you could record this in your macro editor and make the conversion an even happier experience )à
1. Paste the offending text into MS Word. 2. Edit/Replace 3. If (you have a lot of spaces) Then enter two spaces in FindWhat and be sure that ReplaceWith is EMPTY - Hit ReplaceAll Button 4. If (there are lines ending/starting where they should not - ie extra paragraph marks) Then enter ^p^p in FindWhat and ^m in ReplaceWith - Hit ReplaceAll Button. This replaces adjacent paragraph marks with page breaks. 5. Continuingà enter ^p in FindWhat and a single space in ReplaceWith - Hit ReplaceAll Button. This will eliminate the end/start problem. 6. Continuingà enter ^m in FindWhat and ^p in ReplaceWith - Hit ReplaceAll Button. This will insert the end of paragraph mark. Rather than inserting 2 end of paragraph marks, consider formatting you paragraph Format/Paragraph/Spacing - After and use 6 points. This will set off each paragraph without having to insert another character.