Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing fixed-width text (2000/sr1)

    Is there any way of preventing Excel from 'helping' with the column markers? I need to import several different 2-column text files. Excel sets the column properly on the first column but the 5k-byte second column is subdivided into dozens of columns. It appears that the only thing to do at that point is double-click all the wrong markers, which is a very time-consuming and tedious task. Any help would be *greatly* appreciated.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Importing fixed-width text (2000/sr1)

    Select "delimited" and uncheck all the delimiters and you will get one big column.
    You can get the first column out using the LEFT function. Mid/Right/left could be used on the other column to subdivide. If you do this a lot a macro could be created.

    Steve

  3. #3
    Lounger
    Join Date
    Sep 2002
    Location
    Cleveland, Ohio, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing fixed-width text (2000/sr1)

    You can also select the entire sheet, then place your pointer between 2 column headers and either double click to autosize or click and drag out to a specific size. This will resize all the columns of your spreadsheet at once.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •