+ Reply to Thread
Results 1 to 4 of 4

Import from text files and split into columns in Excel

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Import from text files and split into columns in Excel

    Dear Experts,

    I need help in importing data from a text file into excel then splitting the data into different columns.

    Here is a copy of the sample data called "EPN.TXT".

    Many thanks for your help.

    Regards,
    Kay
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Import from text files and split into columns in Excel

    It's without order and composition. Is this a text-based screenshot ?
    Is the system from which it's generated can not create any ordered/sorted txt file with separators ?
    What is what in this txt file ?
    Give an example of the result of the data you would like to obtain.
    Attached Images Attached Images

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Import from text files and split into columns in Excel

    They are separate. The items around the "Page Total" should be ignored. Many thanks.

    P.S. I was away from the office for several weeks and did not check on the forum.. I am sorry for the late response.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Import from text files and split into columns in Excel


    Hi !

    Attach at least a source text file and a filled expected result workbook according to this text file …

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 01-04-2017, 03:35 PM
  2. Import text file into excel and split data in specific sheets
    By chirilaionut in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-03-2013, 07:04 AM
  3. problem with: import text files to excel -- format text
    By karthik123qwe in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-25-2012, 03:53 AM
  4. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  5. Import many text files into excel.
    By lohengrin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2012, 09:25 AM
  6. Excel 2007 : Import text files to Excel
    By chulee in forum Excel General
    Replies: 3
    Last Post: 03-08-2010, 07:25 PM
  7. Import 2 text files into 2 separate columns?
    By tcurrier in forum Excel General
    Replies: 3
    Last Post: 02-11-2006, 03:13 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