Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 08, 11:26 AM posted to microsoft.public.excel.newusers
kf kf is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 3
Default How do I copy a word table into excel

I'm trying to copy a word table (contains multiple paragraphs) into excel but
excel breaks each Word cell into several rows.

Is there a way to copy a Word table into Excel cell by cell.


  #2   Report Post  
Old November 12th 08, 02:50 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How do I copy a word table into excel

Make a text box in Excel and paste to this. Excel is not a word processing
app
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"KF" wrote in message
news
I'm trying to copy a word table (contains multiple paragraphs) into excel
but
excel breaks each Word cell into several rows.

Is there a way to copy a Word table into Excel cell by cell.



  #3   Report Post  
Old November 13th 08, 04:46 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default How do I copy a word table into excel

Hi,

1. Save your Word document.
2. Select the entire table
3. Press Ctrl+H
4. Click More
5. Open Special and choose Paragraph Mark
6. Click Replace All
7. Click No to checking the rest of the document.
8. Copy the table
9. Move to Excel and Paste.
10. Close the Word document without saving.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KF" wrote:

I'm trying to copy a word table (contains multiple paragraphs) into excel but
excel breaks each Word cell into several rows.

Is there a way to copy a Word table into Excel cell by cell.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i copy an excel spreadsheet into word document with a table db Excel Discussion (Misc queries) 1 January 23rd 08 04:16 PM
Copy table from Word Document to Excel Mythili Excel Discussion (Misc queries) 0 May 3rd 07 10:50 AM
Copy / paste from a table in word .doc to excel .xls worksheet Paul Excel Discussion (Misc queries) 1 April 29th 07 03:58 PM
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) [email protected] Excel Discussion (Misc queries) 2 November 29th 05 08:22 PM
Copy & Paste table from Excel to Word Johnny37 New Users to Excel 1 October 10th 05 06:26 PM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017