+ Reply to Thread
Results 1 to 2 of 2

How to get data from text file to excel

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    vijayawada
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to get data from text file to excel

    Hello Everyone,
    I need code for getting dta from text file to excel. i want the text to be appear like this.

    eg: Organisation Name : ALPHA CELSIUS PTE LTD
    Business Address : #02-42 Woodlands East Industrial Estate
    Singapore 738734
    Tel : (65) 6753 6177
    Fax : (65) 6753 6788
    E-mail : [email protected]
    Website : -
    Contact Person : MR DICKY LOW - Engineer
    Business Description : Industrial, commercial, refrigeration, air-conditioning, refrigeration plant equipment & coldroom, design, supply, installation & service


    the text is like this in notepad. I need them to split this data into corresponding columns like

    Organisation Name Business Address Tel : Fax : E-mail Website Contact Person Business Description
    ALPHA CELSIUS PTE LTD #02-42 Woodlands East Industrial Estate (65) 6753 6177
    Singapore 738734


    I want code for this can anyone help me?

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    198

    Re: How to get data from text file to excel

    I have one solution that reads the text file
    in the exact format you have it: 9 rows of data
    in each set, followed by sets of data with
    nine rows each, and all rows except the country/zip
    row are delimited by one occurrence of " : "
    This may work for you if your data is consistent
    with the format you provided. My attachment
    includes two sets of records for testing purposes.

    Copy both the Excel file and text file to the same folder
    to try it out. Open up Module1 and run the Test_GetData
    function to bring your data into Sheet1.

    Good luck with your project.
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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