![]() |
#1
|
|||
|
|||
![]()
Hi all,
Here is the situation. I have a document (call this document #1) with 75 questions, with the following format: Question #1 (ACCCC.101111REG) Question #2 (ACCCC.101115REG-SIM) Question #3 (ACCCC.900537REG-P2-AR) ...... Question #75 (ACCCC.910888REG-P2-AR) Below is the output I was looking for and a solution was given to me with the following wildcard: Find = Question #([0-9]@) \(ACCCC*\) Replace = \1. 1. 2. 3. 4. ... 75. ================================================== =============== Now, I have a second document (call this document #2) with 40 questions, with the same format as the one above (notice this one also starts with Question # 1). Question #1 (ACCCC.1011201) Question #2 (ACCCC.1011305-SIM) Question #3 (ACCCC.900522037-P2-AR) ...... Question #40 (ACCCC.910888REG-P2-AR) I would like to know if there is a way to convert Question #1 to Question #76 and so on with a code/macro. The output will look like this: Question #76 (ACCCC.1011201) Question #77 (ACCCC.1011305-SIM) Question #78 (ACCCC.900522037-P2-AR) ...... Question #115 (ACCCC.910888REG-P2-AR) As always thank you for your support. Cheers! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Style in Use Macro-Need Help Optimizing Code | freda0255 | Word VBA | 4 | 08-04-2014 07:35 PM |
![]() |
OTPM | Project | 4 | 08-22-2013 01:33 PM |
Need Macro code for Outlook | gbaker | Outlook | 0 | 04-11-2013 10:29 AM |
![]() |
chefmate | Excel Programming | 1 | 08-26-2012 01:04 AM |
Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |