3 Effective Ways to Extract Cell Texts Only from Your Word Table

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.        The Invisible Borders

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.Select Text Only

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.

  1. First and foremost, click the plus sign on the upper-left corner to select the table.
  2. Next click “Layout” tab under “Table Tools”.
  3. Then click “Convert to Text” in “Data” group.
  4. Now there shall be the “Convert Table to Text” dialog box. Choose a separator to separate the text and click “OK” lastly.Select Table->Click "Layout"->Click "Convert to Text"->Choose Separator->Click "OK"

I strongly recommend choosing “Tabs” as separator, because it can leave text right on the very position. Here is what it looks like:Convert Table to Text

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:Copy with Cell Borders

  1. To begin with, click “Developer” tab and then the “Visual Basic” to open the VBA editor. Or press “Alt+ F11” instead.Click "Developer"->Click "Visual Basic"
  2. Then click “Normal”.
  3. Next, click “Insert”.
  4. And choose “Module”.Click "Normal"->Click "Insert"->Click "Module"
  5. Next double click it to open the editing area.
  6. 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
  1. Finally click “Run”.Paste Codes->Click "Run"

You can check the result:Result of Runnig Macro

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

Your email address will not be published. Required fields are marked *