View Single Post
 
Old 10-26-2014, 05:41 AM
rsrasc rsrasc is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Looking Again for Another Code/Macro

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!
Reply With Quote