need to copy from word to excel

[April in NC]

Hi. I need to copy a table created as a Word form into an excel spreadsheet.
The table has a drop down menu option. When I select the text to copy into
excel, I am only able to copy the text that users fill into text fields, and
the information entered into drop down menus will not show up when pasted
into excel. Any help would be greatly appreciated.

 

[Suzanne S. Barnhill]

Try using Save As with the "Save data only for forms" option checked (Tools
| Options | Save). This will save the data in (I think) a text file. Would
that help?

 

[April in NC]

Suzanne,

Thanks, I tried this, but it saved all data in a long string with commas
separating the items from the table. When I tried to move this into excel,
it all copied onto one row, rather than in the same table format as I had
originally used. I found an instruction sheet that mentioned this option,
but had the same problem. I'd appreciate any more ideas you may have.

April

 

[Suzanne S. Barnhill]

In Word, use Table | Convert | Text to Table, separating text at commas. Set
the number of columns for whatever will make sense. You should then be able
to paste the table into Excel.