+ Reply to Thread
Results 1 to 4 of 4

Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines

    Hi all,

    I've spent several hours searching this forum and others. My challenge most closely resembles the issue at the following link:

    http://www.excelforum.com/excel-prog...txt-files.html

    What I would like to do is take a single excel table and export it to multiple text files (each record/row would be its own text file). Column A would contain the name of the text file. Column B - J would be the data to be contained in the text file.

    Here is the twist: for my purposes, I need the values of columns B - J to be on separate lines within the individual text file (so there is a 9 line text file for each record in the Excel table).

    Something like the following would serve as an example --

    Excel (I'm substituting the cell identifier for what would be actual values in the cells):
    A1,B1,C1,D1,E1,F1,G1,H1,I1,J1
    A2,B2,C2,D2,E2,F2,G2,H2,I2,J2
    ....
    A500,B500,C500,D500,E500,F500,G500,H500,I500,J500

    would end up exporting 500 text files such that A1.TXT would contain 9 lines as follows:
    B1
    C1
    D1
    E1
    F1
    G1
    H1
    I1
    J1

    Please let me know if I can clarify anything or provide any other information. Your help could save me a scary amount of time.

    Many thanks in advance,

    Rob

  2. #2
    Registered User
    Join Date
    01-15-2008
    Posts
    16

    Re: Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines

    Another way:
    Please Login or Register  to view this content.
    Post responsibly. Search for excelforum.com

  4. #4
    Registered User
    Join Date
    12-06-2012
    Location
    Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines

    Hi,

    I just want to say thanks so much for your response. Honestly I've not had a chance to try out Chippy's work yet; CriticalBill's did exactly what I needed.

    In any event, this saved me an enormous amount of time. To both of you -- I'm impressed by your prowess, and I'm incredibly appreciative of your willingness to share your knowledge/talents with me.

    Often I can figure things out by just reading the forums, but it's a very good feeling to know there are folks out there who will help me out when needed.

    Thanks again -- and happy holidays, etc.

    Best,
    Rob

+ 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