+ Reply to Thread
Results 1 to 2 of 2

Parsing Text file to Excel

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Parsing Text file to Excel

    As a newbie its very difficult for me.
    I request the gurus to kindly help to sort this problem.
    The text file which is containing header and footers which are not required in workbook.
    I have attached the text file and a formated data excel file.
    Some one please give me a start ? help me.
    Thanks in Advance.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    Woodinville, WA
    MS-Off Ver
    Office 365

    Re: Parsing Text file to Excel

    Hi fareen
    My best effort was to open your text file using Excel. It stops and asks for a delimiter during the import. You need to specify the delimiter as the | character. This is the shift key of the \ character. Then you text file at leaste comes in to separate cells and is similar to what you want. The next thing to do would be, remove unwanted rows of data, compressing it using Excel VBA.

    I hope this gives you a start.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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