Re: Converting text into tables

Subject: Re: Converting text into tables
From: "Jane Bergen" <jane -dot- bergen -at- usa -dot- net>
To: "Paul Hanson" <PHanson -at- Quintrex -dot- com>, "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Tue, 12 Sep 2000 15:43:20 -0500

About all you can do is to replace the spaces with a tab (in other words,
the "Find What" is five spaces, if that's the correct number, and the
"Replace With" is a single tab character).

A shortcut that many people, at least in my experience, don't know about
is the vertical selection in Word. Hold the Alt key while you select down
in a straight line. It's great for eliminating columns, bad spacing in
lists, etc. For example, a document has a bullet list in which someone
spaced once before each bullet instead of properly adjusting the margin:

<sp> * item
<sp> * item

I use the vertical select to select only the spaces <sp> in the list, then
click delete just one time to get this:

* item
* item

The easiest, of course, is the search-and-replace, but the vertical select
feature may help you, too.

Jane Bergen

----- Original Message -----
From: "Paul Hanson" <PHanson -at- Quintrex -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Sent: Tuesday, September 12, 2000 1:54 PM
Subject: Converting text into tables

> I have a text file of a directory that is 42 pages long. The following
> is a sample of the data I'm working with:
> 000#0001 Standard HELP Phrases
> 01/04/95 FFTAS400
> <snip>
> I'm familiar with converting text to tables using Word if you have a
> separator, but in this case, there is nothing to separate the columns.
> Is there a way to take this information and put it into Word with the
> above four columns and to add a fifth column for a date formatted as
> 09/12/2000. I need this column so I can sort by it. I tried copying and
> pasting my .txt file into Excel, but it put everything in one column
> (A). I'm trying to avoid manual manipulation, but that's the way I'm
> heading.
> > Ideas, suggestions, comments, solutions, etc. appreciated.
> Paul Hanson
> Quintrex Data Systems

Previous by Author: Re: New writer needing advice
Next by Author: Installation menu (was Re: Online manual: installation, password protection?)
Previous by Thread: RE: Converting text into tables
Next by Thread: SOLUTION: Converting text into tables

What this post helpful? Share it with friends and colleagues:

Sponsored Ads

Sponsored Ads