+ Reply to Thread
Results 1 to 3 of 3

Conversion of .txt file to excel

  1. #1
    Registered User
    Join Date
    08-04-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    61

    Conversion of .txt file to excel

    Hi,

    I have file in .txt .
    I need to convert the file o proper readable Excel file .

    Similarly i do not need the middle portion (i.e having some narration like-Service OutLet : 1949
    Account No : 194937000010054 INR RETAIL BANKING SUSPENSE ACCOUNT
    Gl Sub Head Code : 37000 SUSPENSE ACCOUNTS
    B/F Balance : 62,500.00Cr)

    Please assist me converting the file to Excel and delete the middle portion

    Thank You
    Kapil
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Conversion of .txt file to excel

    This will get you started on the right track.

    You will need to use TEXT FUNCTIONS, and carry out a lot of cell dragging & formatting to get it right.
    Attached Files Attached Files
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  3. #3
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    68

    Re: Conversion of .txt file to excel

    The word document has the explanation. The spreadsheet has the
    imported data. For ease of display I shorted the separator
    lines ----- and had the dates aligned to the left they were right
    and left aligned.

    Let me know if this is what you wanted to happen!
    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)

Similar Threads

  1. pdf to excel file conversion
    By srinivasan1965 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2016, 01:54 PM
  2. conversion of text file(delimited) into Excel file using macro
    By thara.p24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2014, 08:35 AM
  3. [SOLVED] XML file conversion to Excel file using macro
    By thara.p24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2014, 06:47 AM
  4. Excel File Conversion
    By Cincy in forum Excel General
    Replies: 5
    Last Post: 07-29-2013, 05:37 AM
  5. Excel file conversion
    By RCPhinney in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 06:50 PM
  6. Excel file conversion?
    By Bobby P. in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 10:18 AM
  7. Excel File Conversion
    By Turquoise_dax in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 09:59 AM

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