Eliminate excel table format when pasting to Word

[skyport]

I have data in multiple cells in one column (K). I need to copy and paste those cells onto a Word document. The problem I'm having is when I do that it appears that each cell that is being pasted onto word is within its own table and I'm assuming that the entire column of cells I'm pasting is a table itself. I need to be able to accomplish two things: First, how can I was eliminate the table formatting when it is pasted onto word and then secondly, make sure the existing formatting of the text that was within the cells does not change.


Example: The data in each cell might contain words that are underlined and some that are in bold etc. if I do a special paste of the Excel cells onto word, it will eliminate the table formatting however, it also eliminates the underlining, words that are in bold and other important features of the text within the cells that need to be retained.


Does anyone have a solution for this?


Need to use this on windows seven and word/excel 2000, PC not Mac.

 

[brucef2112]

If your data you want to copy in a Table on the spreadsheet, you can select the cells in the table and copy.
in a blank sheet do a paste special > values then do another paste special > format.

Now select the range that you did the paste special and copy. then go to word and paste. the data should be in a single table (not a nested table) with the formating shown in excel.

 

[skyport]

Hi Bruce, thanks fir helping me. I followed the instructions but it still leaves the text result on Word formatted in tables and it loses the bolded text.

 

[skyport]

Also I do not believe the data in excel is in a specific table. I simply observe it seems to lay it out in table for mat on word when pasted

 

[brucef2112]

Ok, so it's not in an Excel table, just regular columns/rows.
So when you paste into Word you want each cells values to be consecutive text strings while also maintaining the text formating it had in Excel?

Excel
__A____B_____C___
| Cat | Dog | Mouse
------|-------|---------
|Cow | Now | Wow
------------------------

Word
Cat Dog Mouse
Cow Now Wow

This may show better with code tags.

[B]Excel[/B]
___A_____B_______C___
| [B]Cat[/B] | Dog  | [COLOR=#B22222][B]Mouse[/B][/COLOR]
------|------|-------
| [COLOR=#00FF00]Cow [/COLOR]| [I]Now  [/I]| [U]Wow[/U]
---------------------

[B]Word[/B]
[B]Cat[/B] Dog [COLOR=#b22222][B]Mouse[/B][/COLOR]
[COLOR=#00ff00]Cow [/COLOR][I]Now [/I][U]Wow
[/U]

 

[skyport]

You are correct and your example above is well illustrated. As you have shown, the end result would retain things such as different font colors, underlined items, italics and bold.


The key issue is to eliminate the other Excel formatting that appears to paste the data into tables formatting onto word by virtue of the fact that they are coming from individual cells from the Excel program. This plays absolute havoc when trying to work with data once it has been pasted onto the word document. The effect of this can be seen when a column of cells from Excel are pasted onto word using paste special, using the rich text format selection and all the borders of the table show up around the different cells of information indicating some form of formatting coming from Excel and ending up on the word document. It is precisely that formatting I need to be able to try to eliminate to make this work. However, when you look at the document after trying it with the paste special as I just described, you'll note that some of that formatting is originally while working in Excel to allow for a very important function that occurred on the Excel document and that being the distance of one cell spacing between the actual cells that contain the data, which is supposed to create that gap or space between paragraphs or cells of the data when it is later pasted on the word document. Example: On the original Excel sheet and column to be copied, you would have data in cell one, then cell two would be blank (thereby creating the space desired) followed by cell number three which of course would have data, and this process would be continued throughout the column.

 

[Macropod]

Simply paste the text into Word as a table, then use Word's Table-to-text tool to get rid of the table.

 

[brucef2112]

Macropod Answer +1

1. Select the table.

In Word 2003 and earlier:
Table > Convert > Table to Text Then follow the next prompts for how to separate the text in each cell.

In Word 2007, on the contex layout tool Table Tools > Layout tab in the Data group (far right), click Convert to Text

I can't confirm if later versions are the same.

 

[skyport]

Guys that did it. Worked perfectly. Thanks for your help