Closed Thread
Results 1 to 2 of 2

How can I save each row of a spreadsheet as separate text files?

  1. 08-11-2020, 03:39 PM #1
    maxim545
    maxim545 is offline
    Registered User
    Join Date
    08-11-2020
    Location
    NY, USA
    MS-Off Ver
    365
    Posts
    6

    Question How can I save each row of a spreadsheet as separate text files?

    I would really appreciate some help here!!
    I have a spreadsheet with >4000 rows, where each row has 2 columns. I want to save each row as a separate text file. How can I do that?
    An example of the structure of the data:

    ID (number) Report (text)
    1645 Today is a beautiful day...
    1967 Today the sun is shinning
    2389 Today is a rainy day...

    I need separate txt files containing each report and hopefully each file under the name of the respective ID.
    Reply With QuoteRegister To Reply
  2. 08-11-2020, 03:46 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: How can I save each row of a spreadsheet as separate text files?

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here

    https://www.excelforum.com/excel-pro...ext-files.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I save each row of a spreadsheet as separate text files?
    By maxim545 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-11-2020, 04:56 PM
  2. How can I save each row of a spreadsheet as separate text files?
    By maxim545 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2020, 03:48 PM
  3. [SOLVED] Save the Output in Separate CSV Files
    By aashishni in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-20-2018, 03:53 PM
  4. [SOLVED] save all sheets as separate text files
    By Minnesaenger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2015, 02:25 AM
  5. Divide worsheet and save as separate files
    By Colin Hayes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] Divide worsheet and save as separate files
    By Colin Hayes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Divide worsheet and save as separate files
    By Colin Hayes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1