Copy & Paste Microsoft word to Microsoft Excel - TechRepublic
Question
May 2, 2007 at 03:36 PM
dbacks3449

Copy & Paste Microsoft word to Microsoft Excel

by dbacks3449 . Updated 12 years, 12 months ago

Hi,

I was trying to find a way to copy content from MS word table to MS excel. The problem I’m having is when I cut and paste a contents from a table, every row (with multiple lines) from word is treated as single row in excel. Is it possible it gets pasted in same row.

for example:
I have a table in Word with 4 columns and two of the columns have content with multiple lines (may be 10 lines)..when I cut and paste the table on excel, the 10 lines are treated as 10 rows.

Greatly appreciate if anyone has any ideas or formula that I can use to tackle this situation.

Thanks,
dbacks

This discussion is locked

All Comments