In this article, we would like to show you 3 methods to extract only the cell texts while coping from a Word table.
Every time in the intention to copy texts from a Word table, it’s easily to select the entire cell. Thus, when we paste cell texts somewhere else, the cell borders are very much possibly go there too. Without much to say, cell borders are not favored in such case. Therefore, it’s necessary to eliminate them.
Then the first thought that could strike to our mind may be to make the cell borders invisible. However, it’s far from enough. Since cell borders only go invisible, they are actually right here, which can mess up the whole document formatting in the future. Hence, it’s better they just gone.
Method 1: Select Carefully
It’s known to all that select carefully can enable you to have the cell text in selection only instead of the entire cell. A small tip to that is to select the text from the end to the start. What’s more important, stay cool and do it patiently.
Method 2: Convert Original Table to Text
Before starting copying cell texts, you can choose to convert the original table to text first, so you can decrease the chance of accidentally selecting the whole cell.
- First and foremost, click the plus sign on the upper-left corner to select the table.
- Next click “Layout” tab under “Table Tools”.
- Then click “Convert to Text” in “Data” group.
- Now there shall be the “Convert Table to Text” dialog box. Choose a separator to separate the text and click “OK” lastly.
I strongly recommend choosing “Tabs” as separator, because it can leave text right on the very position. Here is what it looks like:
You can feel comfortably to copy the information you need now.
Method 3: Run a Macro
In case some people feel more ease to select the entire cell, we also offer remedy to cure the headache.
It may take the following form:
- To begin with, click “Developer” tab and then the “Visual Basic” to open the VBA editor. Or press “Alt+ F11” instead.
- Then click “Normal”.
- Next, click “Insert”.
- And choose “Module”.
- Next double click it to open the editing area.
- Paste the bellowing codes there:
Sub ConvertAllTablesToText() Dim objTable As Table Dim objParagraph As Paragraph For Each objTable In ActiveDocument.Tables objTable.ConvertToText Next objTable For Each objParagraph In ActiveDocument.Paragraphs If objParagraph.Range.Style = "Caption" Then objParagraph.Range.Delete End If Next objParagraph End Sub
- Finally click “Run”.
You can check the result:
Rescue Corrupted Files
Smart phones, pads, laptops and PCs, all kinds of tablets and digital devices are penetrating into every aspect of our life. On one hand, we have to work with them. On the other hand, we love to entertain ourselves with them. Therefore, the file and personal information security can be on the line if the data breach is happening. Luckily, as for the broken files, there are numerous corrupted Word file recovery tools.
Author Introduction:
Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including Excel problem fix product and pdf repair software products. For more information visit www.datanumen.com
Leave a Reply