#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Need Macro to Replace Certain Text
Put in a macro and working great! Thanks!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Find and Replace Macro | amparete13 | PowerPoint | 3 | 03-11-2014 05:29 AM |
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 |