Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.word.newusers
BK BK is offline
external usenet poster
 
Posts: 144
Default Pasting Table Info from Word to Excel

Using Office 2003. I have created a table in Word where the first column is
address information on 3 lines in one cell (Name, Address, City State Zip)

Before going further with this Word table, I decided I really wanted to
track the information in Excel. Having trouble pasting the 3 lines of
information from the Word table cell into one cell in Excel. It keeps
pasting into three cells (i.e. A1 gets the name, A2 gets the address, A3
gets the city state zip). I'd like these three lines of information to
paste into one three-line cell in the Excel table.

I've tried changing the Word table so that there is a manual line break at
the end of each line rather than a hard return. No difference when I paste
into Excel.

I've tried doing a paste special in Excel after I copy from Word. No
difference.

There must be something I haven't thought of trying.


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Linking Text from Excel to Word heyz Microsoft Word Help 9 December 23rd 08 04:58 AM
I am having difficulty with deleting headers and footers LHD New Users 5 July 24th 06 01:44 AM
Change paper size; Word changes to invalid margins OhioTech New Users 10 July 6th 06 02:00 PM
Difficulty pasting Excel data into Word table only in XP versions Digitonomy Tables 0 February 28th 05 12:33 AM


All times are GMT +1. The time now is 10:27 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"