Indent issue when copied from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GainesvilleWes - 30 Apr 2007 17:33 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2007 17:52 GMT

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.

Signature

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

> Good Morning,
>
[quoted text clipped - 36 lines]
>
> Any suguestions?

Reply to this Message

GainesvilleWes - 30 Apr 2007 18:01 GMT

Wow.

Thank you for your prompt reply.
I will look at the link you provided me.

Thank you again.

>If you want to provide users with a convenient way of entering data, use a
>user form.
[quoted text clipped - 11 lines]
>>
>> Any suguestions?

Reply to this Message