Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2014, 07:48 AM
rsrasc rsrasc is offline New Find/Replace Wildcard Needed Windows 7 64bit New Find/Replace Wildcard Needed Office 2010 64bit
Competent Performer
New Find/Replace Wildcard Needed
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default New Find/Replace Wildcard Needed

I would like to know how to put the following info into a find/replace wildcard



A: A.
B: B.
C: C.
D: D.


to be replace with

A.
B.
C.
D.

Thanks!
Reply With Quote
  #2  
Old 11-11-2014, 09:05 AM
gmaxey gmaxey is offline New Find/Replace Wildcard Needed Windows 7 32bit New Find/Replace Wildcard Needed Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Here is a recorded macro. I normally don't use Selection.Find:

Code:
Sub Macro1()
'
' Macro1 Macro
'
'
  Selection.Find.ClearFormatting
  Selection.Find.Replacement.ClearFormatting
  With Selection.Find
    .Text = "([A-D]: )([A-D].)"
    .Replacement.Text = "\2"
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchAllWordForms = False
    .MatchSoundsLike = False
    .MatchWildcards = True
  End With
  Selection.Find.Execute Replace:=wdReplaceAll
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 11-11-2014, 09:46 AM
rsrasc rsrasc is offline New Find/Replace Wildcard Needed Windows 7 64bit New Find/Replace Wildcard Needed Office 2010 64bit
Competent Performer
New Find/Replace Wildcard Needed
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default

Thanks Mr. Maxey! Working great!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
New Find/Replace Wildcard Needed Wildcard Find and Replace Ulodesk Word 1 06-23-2014 10:26 AM
Wildcard Find/Replace deletes extra character Cosmo Word 1 06-20-2014 08:49 AM
New Find/Replace Wildcard Needed Need help using WildCard Find & Replace Cayce Word 1 06-09-2014 04:17 PM
New Find/Replace Wildcard Needed How to replace this word file using wildcard zhangzujin361 Word 1 01-18-2014 08:02 PM

Other Forums: Access Forums

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