| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open text file in Excel and remove columns
hi. i have a text file that on my computer when i open it with Excel the
Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open text file in Excel and remove columns
That means the Text Import Wizard has defaulted to "Fixed Wdith"
If you are set for "delimited" you won't have the dividers to drag off. Excel remembers the last setting to be "helpful" Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 11:16:31 -0700, SLP wrote: hi. i have a text file that on my computer when i open it with Excel the Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open text file in Excel and remove columns
I made certain Fixed Width was selected on all the computers I tried it on
yesterday. Any other ideas? "Gord Dibben" wrote: That means the Text Import Wizard has defaulted to "Fixed Wdith" If you are set for "delimited" you won't have the dividers to drag off. Excel remembers the last setting to be "helpful" Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 11:16:31 -0700, SLP wrote: hi. i have a text file that on my computer when i open it with Excel the Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open text file in Excel and remove columns
Nope.
Gord On Thu, 14 Aug 2008 05:16:00 -0700, SLP wrote: I made certain Fixed Width was selected on all the computers I tried it on yesterday. Any other ideas? "Gord Dibben" wrote: That means the Text Import Wizard has defaulted to "Fixed Wdith" If you are set for "delimited" you won't have the dividers to drag off. Excel remembers the last setting to be "helpful" Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 11:16:31 -0700, SLP wrote: hi. i have a text file that on my computer when i open it with Excel the Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open text file in Excel and remove columns
Thanks. Found out what the problem was and feel really silly. The file I
was opening was one I created late Tuesday night that was saved to my hard drive. While at other computers, I had to use the file that was saved on the server which turned out to be corrupt. Duh. "Gord Dibben" wrote: Nope. Gord On Thu, 14 Aug 2008 05:16:00 -0700, SLP wrote: I made certain Fixed Width was selected on all the computers I tried it on yesterday. Any other ideas? "Gord Dibben" wrote: That means the Text Import Wizard has defaulted to "Fixed Wdith" If you are set for "delimited" you won't have the dividers to drag off. Excel remembers the last setting to be "helpful" Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 11:16:31 -0700, SLP wrote: hi. i have a text file that on my computer when i open it with Excel the Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open text file in Excel and remove columns
Thanks for letting us know the resolution.
Gord On Thu, 14 Aug 2008 08:14:11 -0700, SLP wrote: Thanks. Found out what the problem was and feel really silly. The file I was opening was one I created late Tuesday night that was saved to my hard drive. While at other computers, I had to use the file that was saved on the server which turned out to be corrupt. Duh. "Gord Dibben" wrote: Nope. Gord On Thu, 14 Aug 2008 05:16:00 -0700, SLP wrote: I made certain Fixed Width was selected on all the computers I tried it on yesterday. Any other ideas? "Gord Dibben" wrote: That means the Text Import Wizard has defaulted to "Fixed Wdith" If you are set for "delimited" you won't have the dividers to drag off. Excel remembers the last setting to be "helpful" Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 11:16:31 -0700, SLP wrote: hi. i have a text file that on my computer when i open it with Excel the Text Import Wizard opens and after clicking on the next button, I get a chance to drag unneeded column dividers off the screen. No one else here can do that. Any idea why? I don't recall doing anything special to my computer. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open text file with excel | Excel Discussion (Misc queries) | |||
| open text file in excel | Excel Worksheet Functions | |||
| 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) | |||
| How to open CSV file in XLS without going to "Text to columns"? | Setting up and Configuration of Excel | |||
Hybrid Mode
