Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2012, 10:43 PM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default how to replace a full paragraph with blanks?

as above.



i have 2 scenarios needing help.


1.
I want to remove multiple paragraphs in a document repeating the same thing.

for instance, i want to remove :

answer -
this is Jake
and he likes to
play basketball.


and replace it with NOTHING (not even a space). how do i use the find and replace function to eliminate all the paragraphs with those words? it seems to take in words only instead of paragraphs.


2.

i want to remove paragraphs which start with a particular word.

E.g.

Answer 1 : Jake is a boy
Answer 2 : Joe likes to play.

Any PARAGRAPH that starts with 'Answer' should be automatically removed.

how do i do it?


Thanks in advance!
Reply With Quote
  #2  
Old 10-17-2012, 04:22 PM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

anybody has a solution (or at least a best alternative)?
Reply With Quote
  #3  
Old 10-19-2012, 11:11 AM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

anyone????
Reply With Quote
  #4  
Old 10-22-2012, 01:32 AM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

help please
Reply With Quote
  #5  
Old 10-22-2012, 03:51 AM
macropod's Avatar
macropod macropod is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For 1, a simple Find/Replace should be able to do it. All you need to do is to input the text to be deleted into the Find dialogue. Just make sure to not delete the one you want to keep.

For 2, a wildcard Find/Replace should be able to handle it, where:
Find = Answer[!^13]{1,}^13

In both cases, leave the Replace box empty.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 10-22-2012, 07:22 PM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
For 1, a simple Find/Replace should be able to do it. All you need to do is to input the text to be deleted into the Find dialogue. Just make sure to not delete the one you want to keep.

For 2, a wildcard Find/Replace should be able to handle it, where:
Find = Answer[!^13]{1,}^13

In both cases, leave the Replace box empty.
hi,

the 2nd wildcard format didn't work - it made 0 replacements.

another problem i have is :

e.g.


question A


question B




question C


i want to turn it to :

question A
question B
question C


but using find/replace with ^p in find box, i get :

question Aquestion Bquestion C


what should be the correct function then?
Reply With Quote
  #7  
Old 10-22-2012, 11:18 PM
macropod's Avatar
macropod macropod is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dylansmith View Post
the 2nd wildcard format didn't work - it made 0 replacements.
Did you check the 'use wildcards' option?
Quote:
another problem i have is :

e.g.


question A


question B




question C


i want to turn it to :

question A
question B
question C
If it's just a matter of empty intervening paragraphs, try a wildcard Find/Replace, where:
Find = [^13]{2,}
Replace = ^p
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 10-22-2012, 11:39 PM
dylansmith dylansmith is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Optimizer
how to replace a full paragraph with blanks?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Did you check the 'use wildcards' option?

If it's just a matter of empty intervening paragraphs, try a wildcard Find/Replace, where:
Find = [^13]{2,}
Replace = ^p
yes i did check the option.



this [Find = [^13]{2,}] does not work too - it collapses everything into one line. i.e.

question Aquestion Bquestion C
Reply With Quote
  #9  
Old 10-22-2012, 11:51 PM
macropod's Avatar
macropod macropod is offline how to replace a full paragraph with blanks? Windows 7 64bit how to replace a full paragraph with blanks? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dylansmith View Post
yes i did check the option.



this [Find = [^13]{2,}] does not work too - it collapses everything into one line. i.e.

question Aquestion Bquestion C
Both work fine for me when input as specified for the content you posted. The 'collapsing' suggests you forgot the Replace expression.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to replace a full paragraph with blanks? Mail Merge in Word: creating a rule for blanks cgranada Mail Merge 6 02-27-2017 09:08 AM
Find bullets and replace with paragraph style? cdybdahl Word 1 12-02-2011 02:14 AM
how to replace a full paragraph with blanks? fill blanks in box keevitaja Word 1 05-23-2011 06:34 PM
counting occurences of a value in a range but not including 0's nor blanks virsojour Excel 0 07-05-2010 01:34 AM
using word/able to fill blanks w/o moving rest Rath Word 3 03-07-2009 08:46 AM

Other Forums: Access Forums

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


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