Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extract data having each record across more than one lines from text file format into excel format

    Hi, I am looking for the easiest way to import the attached text file into Excel to analysis data/information. The file is created by another application and has all the relevant data with header. I need to get the data from text file format into excel format in single line/row as per sample of excel file attached. If you look in text file, data is coming across more than one line. All suggestions are welcome.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Moshin,

    Here is some code that will import your text file and reformat it to accommodate your Orders Details. You can rename the sheet if you like. In cell B1, enter the full path of the text file using my example in place then click the "Import Text File" Button. Assuming the structure of the text file is consistent, the Orders will be imported into the appropriate columns.

    HTH,
    Maud

    Before Import:
    Orders1.png

    After Import:
    Orders2.png
    Attached Files Attached Files

Posting Permissions

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