Thread: [Solved] Find-replace using part of what was found in the replacement text
View Single Post
 
Old 12-18-2014, 03:15 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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 can do that with a wildcard Find/Replace, where:
Find = any one of products ([0-9]@)-[0-9]@>
Replace = product \1

You can use the macro recorder to record the above as a macro - in this case the result is about as efficient as a hand-written macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote