Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need Macro to Replace Certain Text
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2014, 10:03 AM
rsrasc rsrasc is offline Need Macro to Replace Certain Text Windows 7 64bit Need Macro to Replace Certain Text Office 2010 64bit
Competent Performer
Need Macro to Replace Certain Text 		 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Need Macro to Replace Certain Text
Hi all,

I would like to know how the following information could be automated with a macro. Here is the info:


Question #1 (ACCCC.101111REG)
Question #2 (ACCCC.101115REG-SIM)
Question #3 (ACCCC.900537REG-P2-AR)
Question #4 (ACCCC.910555REG-P2-AR)
......
Question #75 (ACCCC.910888REG-P2-AR)


Below is the output that I'm looking for:

1.
2.
3.


4.
...
75.


Hope some one can help me.

Cheers,
rsrasc
Reply With Quote
  #2  
Old 10-22-2014, 03:12 PM
macropod's Avatar
macropod macropod is offline Need Macro to Replace Certain Text Windows 7 64bit Need Macro to Replace Certain Text Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 don't need a macro for that. It can be done with a wildcard Find/Replace, where:
Find = Question #([0-9]@) \(ACCCC*\)
Replace = \1.
You could, of course, record the Find/Replace as a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-24-2014, 06:05 AM
rsrasc rsrasc is offline Need Macro to Replace Certain Text Windows 7 64bit Need Macro to Replace Certain Text Office 2010 64bit
Competent Performer
Need Macro to Replace Certain Text 		 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Need Macro to Replace Certain Text
Put in a macro and working great! Thanks!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Macro to Replace Certain Text Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Help: how to replace hidden text with unhidden text when typing over jdcornelius Word 6 03-28-2014 01:19 PM
Need Macro to Replace Certain Text Find and Replace Macro amparete13 PowerPoint 3 03-11-2014 05:29 AM
Need Macro to Replace Certain Text Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
macro or find/replace JamesVenhaus Word 2 02-27-2012 03:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.

Contact Us - Privacy Statement - Top

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