Solved

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

Posted on 2010-09-09
15
829 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
  • 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
 
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now