Import Wizard

A

AnytimeAnywhere

My boss gets a file in his email that is a .txt file. When he opens the
file in Excel 2000, it doesn't bring up the import? wizard where you can
choose the delimiting options like fixed or comma. How can this be turned
on? Can it be turned on? We've changed the file type from .txt to .csv and
..dat but had no luck.

Thanks,

John
 
A

Alfred Dearnley

Hi John!

I'm assuming this is a data file not created and saved by Excel.

Have you tried Data>Get External Data>Import Text File?

Alf
| My boss gets a file in his email that is a .txt file. When he opens the
| file in Excel 2000, it doesn't bring up the import? wizard where you can
| choose the delimiting options like fixed or comma. How can this be turned
| on? Can it be turned on? We've changed the file type from .txt to .csv
and
| .dat but had no luck.
|
| Thanks,
|
| John
|
|
 
A

AnytimeAnywhere

Correct. This file came from a VAX.

No, I didn't try 'Get External Data.' I'll give that a try.

Thanks!

John
 
D

Dave Peterson

I don't think I've ever seen excel do this.

Just curious: What does the file look like when you open it in Notepad (or your
favorite text editor)?
 
D

David McRitchie

Hi John,
Opening a file in Excel with the .txt file extension should bring up
the Text Import Wizard. Opening with the .csv file extension
will *not* bring up the Text Import Wizard.

If everything is in one column you can select Column A and then
use Data, Text to Columns
to bring up the same dialogs as used in the Text Import Wizard.

If that does not work then you probably do not have spaces and
I would suggest first trying the TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
and if that fails check to see what you really have instead of spaces
which is described there and a topic above.
 
A

AnytimeAnywhere

Thanks for the info!

I'll pass this onto my boss and see if it helps.

Thanks,

John

David McRitchie said:
Hi John,
Opening a file in Excel with the .txt file extension should bring up
the Text Import Wizard. Opening with the .csv file extension
will *not* bring up the Text Import Wizard.

If everything is in one column you can select Column A and then
use Data, Text to Columns
to bring up the same dialogs as used in the Text Import Wizard.

If that does not work then you probably do not have spaces and
I would suggest first trying the TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
and if that fails check to see what you really have instead of spaces
which is described there and a topic above.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

AnytimeAnywhere said:
My boss gets a file in his email that is a .txt file. When he opens the
file in Excel 2000, it doesn't bring up the import? wizard where you can
choose the delimiting options like fixed or comma. How can this be turned
on? Can it be turned on? We've changed the file type from .txt to .csv and
.dat but had no luck. --- John
Click to expand...
Click to expand...
 
Top