HOW TO EXPORT MS WORD TABLE TO EXCEL

-

HOW TO EXPORT MS WORD TABLE TO EXCEL
Sometimes you may find it necessary to transfer your Microsoft Word tables to Excel worksheet. This may be the case where you want to perform some actions possible in excel but not in word. It can also be a way of preparing your work to be transferred into a database. I always do this when I need to capture my MS Word table’s content into a database.
To successfully transfer ms word to excel, follow the steps below:
   A.  Open your MS Word document which has the table(s) you wish to transfer.
1.   Select the entire target table in Word.
2.   Open the “Find and Replace” dialog box. You can use a shortcut to open it by holding down Ctrl and H at the same time.
3.   Click the Replace tab (on the Find and Replace dialog).
4.   In the ‘Find what’ field, enter ^l to select all line breaks.
5.   To replace the line breaks enter ^v in the "Replace with" field.
This is a shortcut for the paragraph symbol ¶, it’s known as a "pilcrow".




6.   Select paragraph breaks by entering ^p.
7.   Replace paragraph marks with two pilcrows (¶¶) for ease in replacement later.
8.   Click “Replace All”.
9.   Copy the table data.
We are now done in Word. Let’s turn to Excel.
      B.  In an Excel Worksheet

1.   Paste your copied table into a desired location in your excel worksheet.
2.   Select the entire data that you have pasted.
3.   Open the ‘Find and Replace’ dialog.
4.In the ‘Find what’ Field, place the cursor inside this field, hold down Alt key and type 0182. This symbol () will appear



5.   In the ‘Replace’ field, hold down Alt key and type 0010. Nothing appears. That is okay, this code is meant to enter a single line break.

6.   Click “Replace All”


You are done now. Look at your results and if satisfied save your workbook. In case you did not get what you desired, go through the steps again and see where you may have gone wrong.
 

Comments

Post a Comment

Popular posts from this blog

How to paste image into picturebox from clipboard with VB.Net

-
Image
How to paste image into picturebox from clipboard with VB.Net If you wish to paste an image into a picturebox from clipboard for your VB.Net project, this is what to do: 1. Add a picturebox to your form. 2. Add a button and copy paste the code below.         Private Sub btnPastePic_Click(sender As Object, e As EventArgs) Handles btnPastePic.Click               'If My.Computer.Clipboard.ContainsImage Then         '    PictureBox1.Image = My.Computer.Clipboard.GetImage         'End If         Dim idata As IDataObject = Clipboard.GetDataObject()         If idata.GetDataPresent("System.Drawing.Bitmap") Then             Dim imgObject As Object = idata.GetData("System.Drawing.Bitmap")             If imgObject IsNot Nothing Then                 Dim img As Image = TryCast(imgObject, Image)                 If img IsNot Nothing Then                     PictureBox1.Image = img                 End If             End If         End If    
Read more

CREATING CRYSTAL REPORTS VB.NET 2012 STEP BY STEP - PART 2

-
Image
Creating A New Report In our part one tutorial ,  we saw how to prepare create a new VB.NET project which we will use in creating and displaying our crystal reports. In this part, we will see how to create the Crystal Report inside VB.NET.  1. Under your project name, right-click and select Add then click New Item. Under Reporting, select Crystal Reports. (Remember we started by installing Crystal Reports for VS 2012 . If you missed this step, please refer to this tutorial here )  2. Give your Report a name and click Add. The diagram below shows the four steps to follow in naming the report and adding it. Once you click Add, you will be taken to Crystal Reports Gallery. 3. In the Crystal Reports Gallery select one of the three options; in our case, we will pick option 2 which is As a Blank Report. So select As a Blank Report. Then under Choose an Expert, select Standard. Finally, click OK button.  4. Back now to your workspace. With the report open(th
Read more

How to Create Crystal Report using Visual Studio 2012 Part 1

-
Image
How to Create Crystal Report using Visual Studio This tutorial will focus on creation of Crystal Report using Visual Studio 2012.  To accomplish this you will require to have: Microsoft Visual Studio 2012. MySQL. SAP Crystal Reports version for visual studio 2012.  For the purpose of this tutorial, we will be using VB.Net.   To start create a vb.net project Open visual studio (2012) and create a new project.   Creating a new project  2. Select VB.NET then click on Windows Forms Application.  Give it a name as shown in item 3 in the screenshot below.    Finally click OK.  Now your project is set. You can now start the process of integrating it with Crystal Reports. 3.Right click on the name of your project.  Click Add and then New Item. 4. Add New Item dialog box will appear. Under Common items select Data tehn select Dataset.  Give it a name and click Add as shown below. Selecting Dataset 5. A Dataset Designer comes up.  Right-cli
Read more