Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Get MS Word Copy/Paste-text to word wrap properly
Tips and Tricks
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.
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.