Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data transfer

ResolvedVersion 2003

Lucy has attended:
Excel Introduction course

Data transfer

How do you transfer word data to excel?

Edited on Thu 17 Jul 2008, 08:56

RE: data transfer

Hi Lucy,

Thank you for your post, welcome to the forum.
Answer to your question:

If your word data is in the form of a table, then the transfer is quite simple, select the entire table (or part of) and copy it.

In your Excel worksheet, select the start cell for your entry and click Paste, if you wish to apply other options try Paste Special and choose from the options available.

If your word data is purely text, you will have to import this as an object, by importing as an object will enable the edit option to be present (double click on the text box to edit it in Word). You can also click the Link check box which will ensure that any changes made to the original Word document will be reflected in your text box in Excel.

To insert the Word Document choose the Menu option, Insert>Object, Choose the tab Create From File and either enter the File path or Browse to navigate to the folder where it is located. Once you have your target document located, select it and click the Insert Button, click the Link tick box to capture any changes, and press OK.
The document will be inserted in a Text box which can be moved to your required location.

I hope that has answered your question, if so please click the resolved link, regards Pete

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.