Need assistance importing Word information to Excel spreadsheet

[astinscience]

I am trying to move information from Word docs into Excel. The information is in the format of numbered lists, as question in tests.

Example:
1. Question
a. answer 1
b. answer 2
c. answer 3
d. answer 4

In the above list, the lettered answers are automatically indented using the "numbering" function in Word.

I am looking to have each question and its subset of answers be included in a single cell. I am planning to do some work organizing test questions, and I'd like to be able to sort them as single units. I know that I can bring them into excel and have each question and answer set compose a single row using transpose, but I'd like to keep them in the format above in a single cell.

Does anyone know a way to make that happen?

Thanks in advance for your attention!

[6StringJazzer]

The way to do this manually is to copy each block of text in Word that you want to appear in a single cell, then in Excel instead of just clicking on a cell and hitting paste, do one of the following before you paste:

• Click F2 to active edit for the cell
• Double-click the cell to activate edit for the cell
• Put your cursor in the formula box to activate edit for the cell

Then paste.

How big is your document?

[astinscience]

Thanks for your reply.

The file will include about 70-100 questions. I could certainly do them manually, I was hoping to find something a bit quicker.

I have found that I can convert the text to a table in Word, where each cell is a question and its possible answers. However, this format does not transfer to Excel when I copy. Each question and each answer is its own cell.