Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-25-2018, 08:41 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default Cleaning up Text

Cleaning up Text Pasted from Websites, E-mails, PDFs etc.
well i tried all these but sadly none worked.


would some kind expert please find the way to remove all these returns?
thanks all
PS we have word 2002
Attached Files
File Type: doc LITTLEBOOKTEMP.doc (20.0 KB, 10 views)
Reply With Quote
  #2  
Old 02-25-2018, 09:43 PM
macropod's Avatar
macropod macropod is offline Cleaning up Text Windows 7 64bit Cleaning up Text 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

Both the manual and macro methods in http://www.msofficeforums.com/word/2...s-e-mails.html work just fine with what's in your attachment...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-26-2018, 05:46 AM
Charles Kenyon Charles Kenyon is offline Cleaning up Text Windows 10 Cleaning up Text Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by anon125 View Post
Cleaning up Text Pasted from Websites, E-mails, PDFs etc.
well i tried all these but sadly none worked.
would some kind expert please find the way to remove all these returns?
thanks all
PS we have word 2002
Is this what you are referring to?
“Cleaning up text pasted from emails or websites”—how to remove excess paragraph or line breaks

It works.
Reply With Quote
  #4  
Old 02-26-2018, 09:39 AM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default

as i said, i tried them all, but nothing worked.
which did you use?
on word 2002?
thanks
Reply With Quote
  #5  
Old 02-26-2018, 12:14 PM
Charles Kenyon Charles Kenyon is offline Cleaning up Text Windows 10 Cleaning up Text Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I'm sorry, but the people trying to help you have no idea which ones you've tried. Saying "I tried them all" does not help.
Please follow the link I gave you and try the steps outlined there.
Report back on what happens, what you want to have happen and where it fails.
Reply With Quote
  #6  
Old 02-26-2018, 01:59 PM
macropod's Avatar
macropod macropod is offline Cleaning up Text Windows 7 64bit Cleaning up Text 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 anon125 View Post
as i said, i tried them all, but nothing worked.
which did you use?
The procedures and macro in http://www.msofficeforums.com/word/2...s-e-mails.html work every Word version ever made for Windows or Mac. And, as I said, they work just fine for your document. Clearly, then, you have not 'tried them all', since it does work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 02-26-2018, 05:30 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
I'm sorry, but the people trying to help you have no idea which ones you've tried. Saying "I tried them all" does not help.
Please follow the link I gave you and try the steps outlined there.
Report back on what happens, what you want to have happen and where it fails.
go to his great website
see all the alternatives.

Find = [ ^s^t]{1,}^13
Replace = ^p
Find = ([!^13^l])([^13^l])([!^13^l])
Replace = \1 \3
Find = [^s ]{2,}
Replace = ^32
Find = ([a-z])-[ ^s]{1,}([a-z])
Replace = \1\2
Find = [^13^l]{1,}
Replace = ^p

Note: Depending on your system's regional settings, you may need to replace all the commas in the above Find/Replace expressions with semi-colons. For example:
[ ^s^t]{1,}^13
becomes:
[ ^s^t]{1;}^13

none worked for me in word 2002
Reply With Quote
  #8  
Old 02-26-2018, 05:46 PM
macropod's Avatar
macropod macropod is offline Cleaning up Text Windows 7 64bit Cleaning up Text 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

And, as stated in that post, those are a:
Quote:
series of wildcard Find/Replace actions
So, did you click on the Find/Replace 'use wildcards' option? I'll bet not... You wouldn't even have to do that if you used the macro, so you evidently didn't bother trying that, either! So much for your 'tried them all' assertion.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 02-26-2018, 06:04 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
And, as stated in that post, those are a:

So, did you click on the Find/Replace 'use wildcards' option? I'll bet not... You wouldn't even have to do that if you used the macro, so you evidently didn't bother trying that, either! So much for your 'tried them all' assertion.
the general public does not know what to do with a macro in word.
below see some of what i did.
thanks
Attached Images
File Type: jpg temp1.JPG (149.5 KB, 16 views)
File Type: jpg temp2.JPG (149.6 KB, 16 views)
File Type: jpg temp3.JPG (145.4 KB, 16 views)
File Type: jpg temp4.JPG (148.3 KB, 16 views)
File Type: jpg temp5.JPG (144.6 KB, 16 views)
Reply With Quote
  #10  
Old 02-26-2018, 06:05 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default

the rest of what i tried, yes using the semicolon as well
thanks
Attached Images
File Type: jpg temp6.JPG (142.0 KB, 16 views)
File Type: jpg temp7.JPG (148.5 KB, 16 views)
Reply With Quote
  #11  
Old 02-26-2018, 06:06 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default

the text was copied and pasted
Reply With Quote
  #12  
Old 02-26-2018, 06:08 PM
macropod's Avatar
macropod macropod is offline Cleaning up Text Windows 7 64bit Cleaning up Text 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 anon125 View Post
the general public does not know what to do with a macro in word.
below see some of what i did.
Which is why the thread even includes a link to instructions for that. Regardless, you've just demonstrated the truth of what I said. You didn't click on the Find/Replace 'use wildcards' option and you haven't 'tried them all'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 02-26-2018, 06:31 PM
anon125 anon125 is offline Cleaning up Text Windows 7 64bit Cleaning up Text Office 2003
Advanced Beginner
Cleaning up Text
 
Join Date: Aug 2013
Posts: 57
anon125 is on a distinguished road
Default note to macropod

i used the scary macro and of course it worked.
thanks for your help Paul

Last edited by Charles Kenyon; 02-26-2018 at 06:52 PM. Reason: Mark as solved
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cleaning up Text Cleaning up a database doctormathis Excel 9 08-10-2017 06:58 AM
Cleaning up Text Text Field [content control] - Default text color vs Filled Text color jackcoletti Word 3 02-01-2017 08:10 AM
Cleaning then managing inbox ash_scotland88 Outlook 0 11-28-2016 06:04 AM
Cleaning up Text Cleaning up Text Pasted from Websites, E-mails, PDFs etc. macropod Word 0 02-06-2016 02:09 PM
Cleaning up Text Unable to download Microsoft Office 2010 after cleaning system Warxfreedom Office 3 01-15-2016 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 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