Copy/Paste from Excel to Word places extra spaces

[Fred]

I'll kick myself if the answer is easy, but here's my
problem. I'm using Office 2003.
I often copy from an Excel template I use for analysis
and past the data to my Word document. These are mostly
columns of numbers, with names.
When pasting into Word I get extra spaces in most of the
number columns. I can remove them, but it is a time
consuming manual task.
Is there an option setting I am missing. The pasted
tables from Excel are a mess when put into Word.

Thanks everyone (anyone).
Fred

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Fred,

Can you show us an example of what you are getting and what you want. Click
on the ¶ button on the toolbar to show the paragraph marks and include them
in the example by holding down the Alt key and typing 0182 on the numeric
key pad at the appropriate places.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Guest]

Okay, here is a try to show you what I am getting:

ASA 217 -
ALAN 242 900,000
ALAN 242 500,000
HELMS 438 200,000
ASIA 441 1,255,000
SIMPSON 195 -
SPINNAKER 215 -
JDA 1026 245,000
ORCA 440 490,000
1300 596 500,000
NORTHLAKE 189 -
SAMMAMISH 193 150,000
PANORAMA 361 500,000

This should be three columns. For some reason Word or
Excel is packing the last column with 14 extra spaces in
each cell in FRONT of the number, making it wrap into a
new line.

Does this help?

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

I cannot replicate the problem. If you want to send me an Excel spreadsheet
from which the data originates, I will look into it.
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
Okay, here is a try to show you what I am getting:

ASA 217 -
ALAN 242 900,000
ALAN 242 500,000
HELMS 438 200,000
ASIA 441 1,255,000
SIMPSON 195 -
SPINNAKER 215 -
JDA 1026 245,000
ORCA 440 490,000
1300 596 500,000
NORTHLAKE 189 -
SAMMAMISH 193 150,000
PANORAMA 361 500,000

This should be three columns. For some reason Word or
Excel is packing the last column with 14 extra spaces in
each cell in FRONT of the number, making it wrap into a
new line.

Does this help?

 

[Fred]

Doug,
Thank you - I have sent sample files to your email
address. I really appreciate this, and will look here
for any reply.
Fred

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Fred,

The spaces result from the Custom format _(* #,##0_);_(* (#,##0);_(*
"-"??_);_(@_) that is applied to those cells in Excel. I am not sure why
that Custom format is being used, as a similar appearance in Excel would be
obtained by using the Number format with the thousands separator and no
decimal places - at least for the data in the spreadsheet that you sent. If
the Number format is used for the cells, there is no padding when pasted to
Word

Result with Custom _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_) format


12/31/01
12/31/02
Change
12/31/03
Change

Commercial
27,523
22,535
-18.1%
30,396
34.9%

RE Construction
6,005
5,406
-10.0%
8,762
62.1%

RE Commercial
17,123
29,078
69.8%
37,377
28.5%

RE Residential
3,422
6,798
98.7%
7,593
11.7%

RE Multi-fam
2,765
3,627
31.2%
5,343
47.3%

Consumer
2,997
2,524
-15.8%
4,629
83.4%

Other
1,044
1,086
4.0%
665
-38.8%


60,879
71,054
16.7%
94,765
33.4%



Result with Number Format



12/31/01
12/31/02
Change
12/31/03
Change

Commercial
27,523
22,535
-18.1%
30,396
34.9%

RE Construction
6,005
5,406
-10.0%
8,762
62.1%

RE Commercial
17,123
29,078
69.8%
37,377
28.5%

RE Residential
3,422
6,798
98.7%
7,593
11.7%

RE Multi-fam
2,765
3,627
31.2%
5,343
47.3%

Consumer
2,997
2,524
-15.8%
4,629
83.4%

Other
1,044
1,086
4.0%
665
-38.8%


60,879
71,054
16.7%
94,765
33.4%



Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
----- Original Message -----
From: Fred Singer
To: (e-mail address removed)
Sent: Wednesday, February 11, 2004 10:07 AM
Subject: Excel paste to Word problem


Doug,

Thank you for offering to look at this. I will attach a sample Word doc
and Excel sheet. It happens all the time when cut from Excel and paste into
Word.



Fred Singer



Doug,
Thank you - I have sent sample files to your email
address. I really appreciate this, and will look here
for any reply.
Fred

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Obviously, the difference in the results is not discernable once the email
deals with it.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
"Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS"