vba excel - Convertiing a Word table to Excel

The UK's most regular instructor-led training courses.
Training information: vba excel · Excel in courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Convertiing a Word table to Excel

Tonia has attended:
Powerpoint Introduction course
Powerpoint Advanced course

by - delegate Tonia [1 post] (2006 Nov 15 Wed, 16:46) Reply

Is it possible to convert a Word table into Excel? If so how?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Convertiing a Word table to Excel

by - trainer Martin bronze contributer [27 posts] (2006 Nov 15 Wed, 21:54) Reply

Hi Tonia,

All you should have to do is copy the table in word and then paste it into the excel. When pasting click in the first cell where you want the information to go. The reason why it is a simple copy and paste is that that a word table cell is the same as an Excel cell, as far as office is concerned.
Hope this is all ok
Martin

· Microsoft Excel Training - Numerical excellence for all
· How to Create Better Excel Spreadsheets: Part One
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How Excel Training Can Improve Your Company's Sales Process
· Take the Anxiety out of Domestic Finances with Microsoft Excel

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips