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.
|