View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.