Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2009, 10:40 AM
geobruin geobruin is offline Eliminate paragraph breaks Windows XP Eliminate paragraph breaks Office 2003
Novice
Eliminate paragraph breaks
 
Join Date: Jun 2009
Posts: 1
geobruin is on a distinguished road
Default Eliminate paragraph breaks

Hi! I am looking for a macro that will eliminate paragraph designations from some text. For example:



Buddy you're a boy make a big noise
Playing in the street gonna be a big man some day
You got mud on yo' face, you big disgrace
Kicking your can all over the place

Singing
We will we will rock you
We will we will rock you

Would appear after the script was run as:

Buddy you're a boy make a big noise Playing in the street gonna be a big man some day You got mud on yo' face, you big disgrace Kicking your can all over the place Singing We will we will rock you We will we will rock you

Thanks for the insight!

Cheers!
Reply With Quote
  #2  
Old 06-12-2009, 06:55 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Eliminate paragraph breaks Eliminate paragraph breaks Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Try using Find and Replace:

1)
Find ^p^p - this is the symbol for a paragraph marker (^p)
Replace **

Replace all

2)
Find ^p
Replace [SPACE]

Replace all

3)
Find **
Replace ^p^p

Replace all


If you record the steps by going to Tools > Macro > New, then you will have created your own Macro!
Reply With Quote
Reply

Tags
macro, paragraph, script

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with line breaks and paragraph breaks in bullet point document philiphunter7 Word 8 05-10-2020 11:51 PM
Eliminate paragraph breaks Paragraph Formats and Page Breaks jthomas666 Word 6 06-15-2016 07:54 AM
Eliminate paragraph breaks Replace paragraph-marks (line-breaks) in tables with a character-string Aztec Word VBA 2 04-02-2013 10:52 PM
Eliminate paragraph breaks Paragraph line breaks muymalestado Word 3 09-25-2011 05:06 AM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft