Results 1 to 2 of 2

Importing Text

Threaded View

  1. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,251

    Re: Importing Text to Excel 2007 not importing correctly

    Works fine for me.

    I copied the sample data into a text file and then used Data | From text to import the .txt file.

    See the attached picture of the settings I used.

    The only thing I can think of is that you have some new line characters in there somewhere but I'm not sure that would give the effect you're seeing. I'd have thought that would be noticeable if you viewed the file in, say, Notepad.

    Perhaps you could upload part of the text file, edited if necessary, and a copy of the workbook you are trying to import it to.

    Regards
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

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