Re: open text file with excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

How is your text file delimited?

If it's tab delimited, then that's the behavior you'll see. Well, that's the
behavior I saw in xl2003, anyway.

I guessed (incorrectly!) that it was just plain old text.

George Applegate wrote:

Dave,

Thanks for your reply. I'd be happy if that's what it did. The
problem is, it automatically parses it into multiple columns so I
can't then do text to columns....

Dave Peterson <petersod@xxxxxxxxxxxxxxxx> wrote:

I think you're going to have to live with the behavior of sticking all the data
in a single column if you use the rightclick|open with method.

But after the data is in column A, you could just select that column and use
Data|Text to columns (xl2003 menus) and parse the data the way you like.

George Applegate wrote:

Is there a way when you open a text file to force it to prompt you for
the layout you want the columns to be instead of it just putting the
data in columns on it own?

If I select a text file to open, and right click on that file, and say
"open with" and choose excel, it automatically imports the text file
but determines the columns on its own.

On the other hand, if I open excel, and then choose the text file to
open, it then gives me the prompt and opportunity to format the data
in the columns by showing me some of the records and letting me select
the breaks.

I want it to give me that prompt whether I open excel and then choose
the text file to open, or whether I right click on the file and say
"open with excel".

Is there some setting in excel I need to look at, or is there some
macro I need to create???

thanks,
ga

George Applegate
gappleg8@xxxxxxxxx

George Applegate
gappleg8@xxxxxxxxx

--

Dave Peterson
.

Relevant Pages

  • Re: Nag message on excel installation with Vista
    ... The old ways are still the best; lovely to use the command ... nag screens in Excel now. ... Havn't found Start/Run in Vista but the comand prompt can be accessed frm ... "Dave Peterson" wrote in message ...
    (microsoft.public.excel.setup)
  • Re: Excel 2007 and Name Conflict Issue
    ... For Excel 97, I must key in different new names 5 times in order to open it. ... "Dave Peterson" wrote: ... rykkim wrote: ... I get a prompt to use a new name. ...
    (microsoft.public.excel.setup)
  • Re: open text file with excel
    ... it automatically parses it into multiple columns so I ... George Applegate wrote: ... On the other hand, if I open excel, and then choose the text file to ... it then gives me the prompt and opportunity to format the data ...
    (microsoft.public.excel.misc)
  • Re: open text file in excel
    ... George Applegate wrote: ... the layout you want the columns to be instead of it just putting the ... On the other hand, if I open excel, and then choose the text file to ... it then gives me the prompt and opportunity to format the data ...
    (microsoft.public.excel.worksheet.functions)
  • open text file with excel
    ... the layout you want the columns to be instead of it just putting the ... On the other hand, if I open excel, and then choose the text file to ... it then gives me the prompt and opportunity to format the data ... George Applegate ...
    (microsoft.public.excel.misc)