?
Solved

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

Posted on 2013-11-19
2
Medium Priority
?
1,054 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 52

Accepted Solution

by:
Rgonzo1971 earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

777 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