If the text is tabulated, like this:
A. BCD 66 joh.str 443-5464
E. FGHU 1234 Wales 444-3245
you can use Excel's import feature. Simply open the
text file [give it .txt extension, if you need] and
use File/Open.... point at this file and Import Wizard
will come up. Nice & Clean.
Also works if the text is delimited, i.e. fields are
separated by some mark:
A. BCD/66 joh str/456-3564
<> Max Timchenko [MaxVT]
<>
<> [log in to unmask]
On Sat, 26 Jun 1999 [log in to unmask] wrote:
> I received a text file that is 1600 names and addresses. I am using
> netscape 4. I want to send these files to either excel 97 or access 97.
> I did a copy and paste in excel but I cannot get them separated out by
> member, address, city, state, zip, phone, and fax. How do I send this
> file to either excel or access then set them up so I can use them to
> either send fax or make mailing labels?
The PCSOFT web site always needs good submissions. If
you would like to contribute to the website, send any
software tech tips or software reviews to:
[log in to unmask]
|