Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 11th 05, 05:46 PM
Don
 
Posts: n/a
Default Copy Word tables to Excel

I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.

  #2   Report Post  
Old February 11th 05, 07:28 PM
Richard Neville
 
Posts: n/a
Default

Replace the hard returns in Word with end-of-line marks (hold down shift key
when you press Enter).

"Don" wrote in message
...
I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.



  #3   Report Post  
Old February 11th 05, 07:31 PM
Martin P
 
Posts: n/a
Default

Change all hard breaks in the table to something like ¥, or anything else
that does not otherwise appear in the text. Then copy to Excel. Use a macro
to change ¥ to a manual line break. You will have to do with a manual line
break; a hard return does not seem possible. I do not have a macro available
right now. What it does is change Don¥Mike to "Don"&Chr(10)&"Mike". Perhaps
somebody else is willing to do the macro part before I get there.

"Don" wrote:

I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.

  #4   Report Post  
Old February 13th 05, 04:31 PM
Martin P
 
Posts: n/a
Default

I have created a macro for the final stage of having your Excel table look
like the Word table (see my other post);

Sub copyhardreturns()
'This program changes ¥ to manual line breaks
For j = 1 To 50
For k = 1 To 50
i = 0
While i < Len(Cells(j, k))
i = i + 1
If Mid(Cells(j, k), i, 1) = "¥" Then
Cells(j, k) = Mid(Cells(j, k), 1, i - 1) & Chr(10) & Mid(Cells(j,
k), i + 1)
End If
Wend
Next k
Next j
End Sub

My procedure is then:

(1) In Word, replace returns with ¥.
(2) Copy the contents of the Word table to Excel
(3) In Excel, run this macro.

You might have to adjust the values for the for ... to ... next part.

"Don" wrote:

I'm sure there might be a solution, I just can't find it
now.....

I have a table in Word that might or might not
contain "returns." I want the table in Word to copy
EXACTLY as is into Excel.

If I have Don (hard return) Mike in one Word table cell.
It splits this into two cells in Excel. Any way to
prevent this. Pasting as a Word document is not an option

Thanks so much in advance.



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
Word address labels to Excel Columns jlbowman Excel Discussion (Misc queries) 4 February 9th 05 06:51 PM
Excel to Word PHIMAN11 Excel Discussion (Misc queries) 0 February 3rd 05 02:41 PM
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 11:26 AM
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 04:43 PM
Excel And Word george Setting up and Configuration of Excel 1 November 29th 04 09:54 PM


All times are GMT +1. The time now is 05:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017