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

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

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