Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2013, 09:29 PM
macropod's Avatar
macropod macropod is offline Text manipulation in MACRO Windows 7 64bit Text manipulation in MACRO Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
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

Hi srt,

You can do this without a macro, using a wildcard Find/replace, where:
Find = (DP )([!^13]{1,})([^13]VD*VX[!^13]{1,}[^13])(DP )([!^13]{1,}[^13])
Replace = \1\2\3DB \2,\5\4\5
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-09-2013, 04:19 AM
srt srt is offline Text manipulation in MACRO Windows 8 Text manipulation in MACRO Office 2010 64bit
Novice
Text manipulation in MACRO
 
Join Date: Mar 2013
Location: Glasgow, UK
Posts: 15
srt is on a distinguished road
Default

Yhouhou!!!!!!

Works pertect!
Thanks so much Macropod
Reply With Quote
  #3  
Old 03-09-2013, 04:59 AM
srt srt is offline Text manipulation in MACRO Windows 8 Text manipulation in MACRO Office 2010 64bit
Novice
Text manipulation in MACRO
 
Join Date: Mar 2013
Location: Glasgow, UK
Posts: 15
srt is on a distinguished road
Default

I do not wish to take a lot of your time but, as it seems dead easy for you

I'm trying to figure out wildcards but.... not yet

I want to find any word begin by : Front*... without any number following
And replace by : **French Border**

44º01’40”N,007º33’06-E
43º58’04”N,007º38’08-E
Frontièrefrancoitalienne43º47’02”N,007º31’47-E
43º45’06”N,007º26’00-E
43º45’06”N,007º16’44-E
43º38’32”N,007º00’00-E
43º37’36”N,006º55’24-E

to

44º01’40”N,007º33’06-E
43º58’04”N,007º38’08-E
**French border**
43º47’02”N,007º31’47-E
43º45’06”N,007º26’00-E
43º45’06”N,007º16’44-E
43º38’32”N,007º00’00-E
43º37’36”N,006º55’24-E


Any idea Macropod?
Thanks

Marc
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text manipulation in MACRO Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
Text manipulation in MACRO Need help on Macro 03- Find text - if text is blank then remove line simpleonline1234 Word VBA 1 02-25-2011 02:28 AM
Text manipulation in MACRO Combobox manipulation vsempoux Word VBA 3 10-31-2009 08:58 AM
Mail merge Field Code Manipulation macjnr Mail Merge 0 09-10-2009 11:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:45 PM.


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