Solved

After paste special using Word 2007, the text looks clumped together.

Posted on 2010-09-09
15
861 Views
Last Modified: 2012-05-10
Hi,

I am having a lot of trouble trying to fix the text in Microsoft Word 2007. Here's the process, I tried copying and pasting special from Excel into word, everything shows up fine, but the letters look clumped up together. The text looks different from everything else in my Word document.

I tried making adjustments with the borders, changing font size, style, but nothing works. Even when I print it out it looks like that.  ExcelSpreadSheet
0
Comment
Question by:vlsllp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
15 Comments
 
LVL 4

Expert Comment

by:abitoun
ID: 33638778
what type of paste special are you using?
0
 
LVL 2

Expert Comment

by:bureshd
ID: 33638803
Looks like a character spacing issue.

Highlight the text in question
Go to the home tab
In the styles area, select the little aarown in the bottom right corner that brings up all the styles on the page
Select the drop down list on the one that is highlighted and select "Modify"
Click "Format" and then "Font" from the drop down list in the bottom left corner
Under the character spacing tab, change the spacing to be expanded by a few points.

0
 

Author Comment

by:vlsllp
ID: 33638850
I went to paste special > paste link > Microsoft Office Excel Worksheet Object

I tried the other ones, but I can't use them because the formatting brings down the visibility of the text. Also, I am told to do it this way. Can you guys tell that the text or font looks a bit strange? I'm not sure if this is a glitch or something. Thank you for your help!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Expert Comment

by:abitoun
ID: 33638911
ok you are pasting it as a picture using html format in order for it to be sent as an image pasted on an email, that ios why you are using pastelink, now once in word, select your object right click, select format object, go to the size tab check what percentage of size it is assigning and change it to 100% this will make the image clear and the letters will not be crumpling.
0
 

Author Comment

by:vlsllp
ID: 33638916
HI Bureshd,

I can see the drop down under change styles, but I can't find the format button. I only see style set, colors, font, and set as default. I am using word 2007. I dont know where to locate the character spacing tab.
0
 
LVL 4

Expert Comment

by:abitoun
ID: 33638953
As i said the paste special you are using is adding a pictyure not actual text so you will not be able to reformat it, the only chance for this paste special to wiork this way is to reformat the picture, now if you want it to be text and change the font eetc. use:
paste special> paste link> formatted text (rtf)
0
 

Author Comment

by:vlsllp
ID: 33638979
I found the character spacing tab, it's right under the drop down in Font. It still doesnt work. I also want to mention to you guys that I can copying and pasting this from Excel 2007. Do you think I need to do something with Excel 2007? The text looks crumpled in Excel, and right after I copy and paste special to Word 2007, it carries over this ugly setting.
0
 

Author Comment

by:vlsllp
ID: 33638997
Hi Abitoun,

when I copy and paste using RTF, it displays everything in a Table. The alignment is misplaced. Is there another option? thanks
0
 
LVL 4

Expert Comment

by:abitoun
ID: 33639078
Ok,

in Excel format your data to look exactly the way you want because this brings the Excel formatting, it should not bring the whole table unless you are selecting it, and if you have hidden rows columns it will select those as well, so it looks like you are ciopying an area that has hidden rows/columns. Try this:

select the area you want to copy, click alt + ; then select copy.

Can you post a sample of the Excel data you want to copy (your actual spreadsheet)
0
 

Author Comment

by:vlsllp
ID: 33639238
Here is the excel spreadsheet, or part of the spreadsheet that I am trying to copy and paste. you notice the font looks funny, but the numbers are normal.
excel.JPG
0
 

Author Comment

by:vlsllp
ID: 33639253
when i click alt + copy, as soon as I click alt + it only selects the numbers and not the text around it, such as equity securities, us government obligations.. I really appreciate your help abitoun!
0
 
LVL 4

Accepted Solution

by:
abitoun earned 500 total points
ID: 33639384
You are very welcome!, i replicated your data in a spreadsheet and paste it with no problem. see attached:
ee-test.docx
EEtest.xlsx
0
 

Author Comment

by:vlsllp
ID: 33639554
HEY ABITOUN! wow thank you so much!   okay, it looks perfect, however, can you teach me how do what you did? I have to do this for 50 pages of work.
0
 

Author Comment

by:vlsllp
ID: 33639564
btw, how do I give you points for answering my question? sorry I'm new to this.
0
 
LVL 4

Expert Comment

by:abitoun
ID: 33639621
I am glad, but i did nothing different from what i told you, formatted my data in excel the way i want it to look in word, then selected the area in this case a17 to e26 then copy then opened word then paste special then paste link then formatted (rft).

If it is not working for you try practicing with the excel test i sent then try to see what is different in your spreadsheet, maybe hidden columns?  then to copy just the visible data press simultaneously alt and the semi colon key (alt;) this will copy the visible part only.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question