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.

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.

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.

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.

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.

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.