Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Indent issue when copied from Excel
Good Morning,
I seem to be hitting a wall here. I have a Excel worksheet set up for users to enter data on. Some of the cells contain several lines of text broken up by blank lines. Example: "Document No: 344 From: Jon To: Jane" When i try to copy it over to Word and paste it into a numbered table, it refuses to paste on the numbered line and instead pastes above it far left justified. Example: .........1. random text .........2. random text Document No. 344 From: Jon To: Jane .........3. where as it should look like this: .........1. random text .........2. random text .........3. Document No. 344 .............From: Jon .............To: Jane .........4. random text (Note: the use of '.........' is to represent indent) Any suguestions? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...ables/200704/1 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Indent issue when copied from Excel
If you want to provide users with a convenient way of entering data, use a
user form. See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm Entering data into Excel and then copying and pasting into Word is not the way to do it. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "GainesvilleWes via OfficeKB.com" u32072@uwe wrote in message news:717bf82b8a42a@uwe... Good Morning, I seem to be hitting a wall here. I have a Excel worksheet set up for users to enter data on. Some of the cells contain several lines of text broken up by blank lines. Example: "Document No: 344 From: Jon To: Jane" When i try to copy it over to Word and paste it into a numbered table, it refuses to paste on the numbered line and instead pastes above it far left justified. Example: ........1. random text ........2. random text Document No. 344 From: Jon To: Jane ........3. where as it should look like this: ........1. random text ........2. random text ........3. Document No. 344 ............From: Jon ............To: Jane ........4. random text (Note: the use of '.........' is to represent indent) Any suguestions? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...ables/200704/1 |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Indent issue when copied from Excel
Wow.
Thank you for your prompt reply. I will look at the link you provided me. Thank you again. Doug Robbins - Word MVP wrote: If you want to provide users with a convenient way of entering data, use a user form. See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm Entering data into Excel and then copying and pasting into Word is not the way to do it. Good Morning, [quoted text clipped - 36 lines] Any suguestions? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...ables/200704/1 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word table truncated when copied to excel | Microsoft Word Help | |||
How do I convert HTML table copied into a Word Doc - into Excel? | Microsoft Word Help | |||
Autoresize a copied Excel table | Tables | |||
Delete Grid lines on document copied from Excel to Word | Microsoft Word Help | |||
unable to print an Excel chart that has been copied into a Word do | Microsoft Word Help |