word course - Text to Table

The UK's most regular instructor-led training courses.
Training information: word course · Word courses london · Microsoft word training

Resolved · Low Priority · Version Standard

Text to Table

by - trainer Pete platinum contributer [803 posts] (2007 Nov 30 Fri, 13:55) Reply

I've got a document in which I have separated columns of information with Tabs, I'd like to put that information into a Table without having to retype it all, can you help?

Version	Date	Location	Places available	Book	Next place rate:
Word Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu	Bloomsbury	0	FULL
2003	2008 Dec 16 Tue	Bloomsbury	3	book now	£210	£215
2003	2009 Jan 22 Thu	Bloomsbury	4	book now	£207	£215
2007	2009 Jan 28 Wed	Bloomsbury	4	book now	£212	£224
2003	2009 Feb 9 Mon	Bloomsbury	6	book now	£170	£207
2007	2009 Mar 4 Wed	Bloomsbury	7	book now	£110	£210
Full Schedule: See all 20 Word Intermediate course dates. Bookings currently available until 10th November 2009.

RE: Text to Table

by - trainer Pete platinum contributer [803 posts] (2007 Nov 30 Fri, 14:00) Reply

Answer to the question:
In your list or text file; items can be separated by commas or tabs (tabs work best), note all lines must have the same number of items.
1. Select the entire list
2. Menu command Table, Convert, Text to Table
3. Under AutoFit behaviour, select how wide to make the columns and table (Fixed column width: and set the desired width; Autofit to contents or AutoFit to window).
4. Under Separate text at; (depending on how the original text items were separated, select Tabs or Commas)
Click on OK
Your text is now in a table with the cell entries being governed by the tab or comma positions.