+ Reply to Thread
Results 1 to 2 of 2

Parsing Text file to Excel

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Parsing Text file to Excel

    Hi,
    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
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,106

    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)

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