open text file in Excel and remove columns

  • Thread starter Thread starter SLP
  • Start date Start date
S

SLP

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.
 
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
 
I made certain Fixed Width was selected on all the computers I tried it on
yesterday. Any other ideas?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Text Files in Excel, Changed Behavior 4
Drag text file to Excel -- stopped working 5
Question: How Excel opens text files 4
Importing text files automaticly. 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
opening extensionless text files 2
how do I remove page headings from an imported text file 1
open text file with excel 3

Back
Top