Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open text file with excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open text file with excel
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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
open text file with excel
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 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 George Applegate |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
open text file with excel
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 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 George Applegate -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with open text file in excel 2007 | Excel Discussion (Misc queries) | |||
I open a CSV file with excel, but the text is separate with comma! | Excel Discussion (Misc queries) | |||
Open text file in excel that has multiple rows of data | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) |