Results 1 to 3 of 3

Converting a Text File to .xls Format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Converting a Text File to .xls Format

    Hi,

    I have received a large file of text and numbers arranged (loosely) in columns in a .txt file that I need to get into a usable form in Excel.

    I'm trying to use the Text Import Wizard but am running into problems geting the column breaks right as there are thousands of rows of data items. As soon I think that I've inserted the break line in the correct place I scroll down a little further to find an item that encroaches into the next column, and when I shift the break line to the right to accommodate this new item I then encroach on the items in this next column.

    Can someone please offer some guidance about how to sort this out?

    Thanks!
    Last edited by andrewc; 10-21-2008 at 11:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting the Format of the Date
    By aki096 in forum Excel General
    Replies: 3
    Last Post: 05-29-2008, 01:02 PM
  2. Macro to Output Custom Text and File Name
    By KenB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2008, 06:34 AM
  3. format to start new line in a single text cell?
    By Pete1000 in forum Excel General
    Replies: 2
    Last Post: 11-08-2007, 03:27 PM
  4. Excel 2003 Not Excelling in Handling 2000 .xls File
    By pands in forum Excel General
    Replies: 4
    Last Post: 02-27-2007, 05:56 PM
  5. Saving a Sheet as Text file
    By Fredriksson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2006, 05:54 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1