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
|