Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2016, 10:50 AM
htown htown is offline using wildcards to delete Windows Vista using wildcards to delete Office 2007
Novice
using wildcards to delete
 
Join Date: Jan 2009
Posts: 8
htown is on a distinguished road
Default using wildcards to delete

I have a table with 100's of cells and I need to do a search for a colon ( : ) and then delete it and everything to the right of it in that cell. I can not figure out what wild card sequence to use in the advanced search and replace dialog. Can a more experienced person lend a helping hand please.

Many thanks,
Houston
Reply With Quote
  #2  
Old 02-02-2016, 01:53 PM
macropod's Avatar
macropod macropod is offline using wildcards to delete Windows 7 64bit using wildcards to delete 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

You could use:
Find = :[!^13]{1,}

Do note there is no way to limit this to just tables - it will match everything from a colon to the end of whatever paragraph it's in anywhere in the body of the document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-02-2016, 02:15 PM
htown htown is offline using wildcards to delete Windows Vista using wildcards to delete Office 2007
Novice
using wildcards to delete
 
Join Date: Jan 2009
Posts: 8
htown is on a distinguished road
Default

Thank you Macropod. I will give this a shot.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using wildcards how do I Find and Add to, not replace Stargehzer Word 3 01-25-2016 09:14 PM
Use wildcards to replace some characters mauuuuu5 Excel 2 12-12-2015 07:27 PM
Wildcards Madcat Word 2 12-21-2014 08:27 PM
using wildcards to delete Search with wildcards imag Word 1 11-05-2014 11:42 PM
using wildcards to delete Help with replacing text with wildcards sbatson5 Word 2 04-13-2012 03:49 AM

Other Forums: Access Forums

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