#1
|
|||
|
|||
Making Table from Text with Many Columns
How do I make a (multi-line, neat looking) table out of the following text? Thanks.
---------------------------------------------------------------- OrderID CustomerID EmployeeID OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry 10253 HANAR 3 1996-07-10 00:00:00.000 1996-07-24 00:00:00.000 1996-07-16 00:00:00.000 2 58.17 Hanari Carnes Rua do Paço, 67 Rio de Janeiro RJ 05454-876 Brazil |
#2
|
|||
|
|||
Put a Tab character between each column. Don't worry about appearance.
Then select your text and convert text to a table, choosing tab delimiter. |
#3
|
|||
|
|||
I have the tabs.
It comes out on 2 lines with some vertical words. Probably it should be 3-4 lines with unbroken words. How can I tell it not to break words? Word document attached. |
#4
|
|||
|
|||
Changing the orientation to landscape and the font size to 7 seemed to do it.
|
#5
|
|||
|
|||
I can't change the orientation, it is part of a (portrait) document. Calibri is used, smallest size is 8.
Last edited by SQLUSA; 07-30-2012 at 02:59 AM. |
#6
|
||||
|
||||
You can use point sizes down to 1pt, in 0.5pt increments, by simply typing the required size into the size combobox.
Also, the document you posted is in portrait layout, not landscape.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Using Calibri 5 worked. I was hoping though for a more readable solution.
|
#8
|
||||
|
||||
You could try Arial Narrow. Being a narrow font, you can use larger point sizes. Ultimately, though, you're going to be constrained by the space you're trying to fit the table into. Reducing the size of the cell margins (typically ~.075in) will also give you more text space.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
I just leave it as it is, unformatted text.
We computer people are used to this kind of unformatted results anyhow. |
#10
|
|||
|
|||
Quote:
Or, select your table and change the orientation to Landscape which should automatically insert the section breaks. Sections / Headers and Footers in Microsoft Word 2007-2010 |
#11
|
|||
|
|||
Thanks Charles.
I find your advise too adventurous for me in the middle of a book document. I just leave it as unformatted text. Computer programmers face this kind of messy text output occasionally, so they better get used to it. |
#12
|
|||
|
|||
OK, I understand not messing with something that is working.
You could try it on a copy, though. |
#13
|
|||
|
|||
One thing I don't get it.
If I make it landscape, is it going to hang out from a portrait document? |
#14
|
|||
|
|||
No, the page will print sideways. People will have to turn the document to read that page. The choice is they can do that or get out a magnifying glass.
|
#15
|
|||
|
|||
Thanks Charles.
Guttenberg would be jealous of the inkjet printer for the capacity to print such tiny font letters. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Columns lines in table have spaces and indents in the borders | lukester | Word Tables | 3 | 07-11-2012 07:01 AM |
Making text equal to another text | gmacx | Word | 1 | 03-05-2012 05:50 PM |
How to sort table having three columns? | Bahir Barak | Word | 2 | 01-20-2011 01:52 PM |
Resize-to-fit Table Columns (PowerPoint) | icu222much | PowerPoint | 0 | 06-06-2010 11:21 AM |
Table of contents, remove spacing and put in 2 columns - need help urgently! | nam085 | Word | 1 | 03-04-2010 08:00 AM |