Solved

Retain formatting but not table structure when Copy/Pasting from Excel to Word

Posted on 2013-11-19
2
1,010 Views
Last Modified: 2013-12-10
Hello,

Is there a way to copy the contents of a range of cells in Excel and then paste what was copied into a Word (2013) doc so that the table structure is lost but the formatting remains unchanged?

Whenever I want to get rid of table formatting (or any other kind of formatting), I generally paste copied content into a text file and then recopy and paste it from there to a Word doc. In that case, any Excel content which is not in the left-most copied column is placed in the text file with a Tab for each column between where it resides and the left extreme of the copied Excel range.

I know that there are several Paste Special options in Word as displayed in the following screenshot, but it seems that any which remove the table structure, also remove all formatting.
Fig. 1Suggestions?

Thanks
0
Comment
Question by:Steve_Brady
[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
2 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39661800
Hi,

After having pasted your text in a table, you could use

Select the table

Click Table Tools / Layout / Data / Convert to text

and choose the separator you want and then OK

Regards
0
 

Author Closing Comment

by:Steve_Brady
ID: 39710191
Thanks
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

705 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