![]() |
#1
|
|||
|
|||
![]()
I have a word document listing a series of True/False Questions (up to 49 questions-only included two (2) here for demonstration), and right after all the questions there are the answers to the questions. Please notice the questions are splitted/separated in two line
The way you see the information below is how it is copy and paste it from the source. What I would like to have is to see if there is a way to automate the information with a macro. Here is how the information in the document looks now..... Question #1 (Q6955) Here is the first question. True False Question #2 (Q6954) Here is the second question. True False Question #1 : True Question #2 : False ================================================== ============================ After the macro is applied, here is how the information should looks like: 1. Question #1 (Q6955)-Here is the first question. A. True B. False Answer: A 2.Question #2 (Q6954)-Here is the second question. A. True B. False Answer: B ========================================== Hope someone can help me! Thanks! |
#2
|
|||
|
|||
![]()
Here is one way: you could do that with a very tiny macro if you set up the document with multilevel list styles.
level 1 style = Question level 2 style = A, B level 3 style = Answer: All your macro need do is toggle the hidden text property of the level 3 style. There would be one modification if you wish to make it that easy. That is, for your level 1 paragraphs, include the text of the question inline with the same paragraph to avoid the need for a style separator or hidden paragraph mark. Hope this helps. |
#3
|
|||
|
|||
![]()
I managed to get partial results using the find and replace option using an excel file but would like to have it in word.
I would like to have a simple macro to convert the following text from: Question #1 Question #2 Question #3 ... Question #150 to the following: 1. Question #1 2. Question #2 3. Question #3 ... 150. Question #150 Thanks! |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom icon, undo/redo for macro, permanent macro | Rapier | Excel | 0 | 08-05-2013 06:30 AM |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |