Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-26-2014, 05:41 AM
rsrasc rsrasc is offline Looking Again for Another Code/Macro Windows 7 64bit Looking Again for Another Code/Macro Office 2010 64bit
Competent Performer
Looking Again for Another Code/Macro
 
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
 



Similar Threads
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
Looking Again for Another Code/Macro VBA Code for adding Macro to QAT OTPM Project 4 08-22-2013 01:33 PM
Need Macro code for Outlook gbaker Outlook 0 04-11-2013 10:29 AM
Looking Again for Another Code/Macro I need help with macro...code needed for automatic sorting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft