Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / September 2003

Tip: Looking for answers? Try searching our database.

Random Formatting...I Want Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Athena - 12 Sep 2003 20:52 GMT
I just hired on with a new company, and I am in charge of
formatting all their long documents.  We have a 90+ page
price list that has been quite randomly formatted using a
series of tabs, spaces, section and column breaks.  This
thing is a piece of work...really defies all logic.  

I'd like to convert the data into Word tables because the
data is constantly changing(there's still enough "fancy"
formatting that Excel may not be the best choice), and
yet, I do not know how to effectively and efficiently move
the data into the tables.  I've been copying a line and
transferring it to the appropriate cell in another
document.  I've got 10,000+ lines, and this has to get out
before the end of Sept.  How do I expedite the process?

Thank You!!!!
Jonathan West - 12 Sep 2003 22:12 GMT
Hi Athena,

That's a tough one. It depends to a certain extent on how random is all is.
First thing to to is take a backup of your orihginal document. The
experiments you will need to do may mess the document up, so you want to
play with a copy and know that if the worst comes to the worst, you can go
back to your original.

They key thing about getting it into a table is getting the data into a
proper tab-delimited format first. Then its a fairly straightforward job to
then do a Convert Text to Table.

I'm not sure where the column  section breaks come in, so in this answer I'm
going to concentrate on the tabs & spaces.

Assuming that every row of the table has an item in every column, then one
way to approach this is to proceed as follows.

1. Use the Edit Replace dialog to replace every tab with two spaces. You can
search for tabs by entering "^t" (without the quotes) in the Find What box
on the dialog.

2. Then use the Edit Replace dialog to replace every example of 2 or more
spaces with a tab. To do this, enter " ^w" (note the space in there) in the
Find What box, and enter "^t" in the Replace With box

3. Hopefully you now have a faily well-behaved tab-delimited list, and can
now Select it and convert it to a table.

If your data includes some blank cells in certain rows, then life becomes a
bit more complex. The procedure I just gave you will not reliably cover such
cases. However, even an imperfect conversion, leaving you with the need to
move some cells around, might be quite a lot quicker than what you are doing
now.

Signature

Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com

> I just hired on with a new company, and I am in charge of
> formatting all their long documents.  We have a 90+ page
[quoted text clipped - 12 lines]
>
> Thank You!!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.