Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2015, 08:41 PM
paik1002 paik1002 is offline Triming a text selection front and back Windows 7 64bit Triming a text selection front and back Office 2010 64bit
Advanced Beginner
Triming a text selection front and back
 
Join Date: Dec 2015
Posts: 63
paik1002 is on a distinguished road
Default Triming a text selection front and back

I'd like to trim everything at the front and rear of a text selection, that is not:
1. alphanumeric characters
2. () [] {} <>
3. ending punctuation marks such as . ! ? : ;

FYI, a selection can have multiple carriage returns at the end of the selection. I'd like to get rid all but one of them as well.



Could it be done using macros?
Reply With Quote
  #2  
Old 12-15-2015, 09:46 PM
macropod's Avatar
macropod macropod is offline Triming a text selection front and back Windows 7 64bit Triming a text selection front and back Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

See: https://www.msofficeforums.com/word/...html#post24698
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-15-2015, 10:11 PM
paik1002 paik1002 is offline Triming a text selection front and back Windows 7 64bit Triming a text selection front and back Office 2010 64bit
Advanced Beginner
Triming a text selection front and back
 
Join Date: Dec 2015
Posts: 63
paik1002 is on a distinguished road
Default

Thank you! I didn't know that more than one Text / Replacement Text pairs could be put into a nest of with... find. Good one.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Triming a text selection front and back Is there a way to print only certain pages in a document front to back? GrahamV2 Word 2 06-26-2013 10:38 AM
Triming a text selection front and back Keep box drawn in front of Video in FRONT position a_gunslinger PowerPoint 1 04-18-2013 07:54 AM
Triming a text selection front and back Selection of all Text for a specific page in word is spanning selection across pages ramsgarla Word VBA 9 12-05-2012 03:23 AM
Triming a text selection front and back Text Box Always in Front joferder PowerPoint 4 05-13-2011 06:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 PM.


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