ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing Data (https://www.excelbanter.com/excel-discussion-misc-queries/10158-importing-data.html)

Cliff-Stouff

Importing Data
 
How do I import a Delimited Text (DOS ASCII file) into Excel
I am using Excel 2000

Gordon

Cliff-Stouff wrote:
How do I import a Delimited Text (DOS ASCII file) into Excel
I am using Excel 2000


File-Open and change the file type to txt. then follow the prompts.

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

Gord Dibben

Cliff

Just open it as is and the Text Wizard will open to allow you to parse
according to type of delimiter.


Gord Dibben Excel MVP

On Wed, 26 Jan 2005 20:21:02 -0800, Cliff-Stouff
wrote:

How do I import a Delimited Text (DOS ASCII file) into Excel
I am using Excel 2000



david roberts

Importing Data
 


"Cliff-Stouff" wrote:

How do I import a Delimited Text (DOS ASCII file) into Excel
I am using Excel 2000



All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com