Importing text file and changing default to delimited

J

juleigha27

I have a file that begins with
;--
The "--" seems to cause excel to think this is a fixed-width file.
When I open it with the text import wizard it defaults to fixed-width
when it should be delimited. It there any way I can change this so I
don't have to go into the import wizard every time I want to open this
type of file and change it to delimited? How does excel decide
whether it is delimited or fixed width?

Thanks,
Julia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top