+ Reply to Thread
Results 1 to 3 of 3

Export to text file keeping text format for one column

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    2

    Export to text file keeping text format for one column

    I need to export a spreadsheet to a txt file (either comma or tab separated) but I need the header row and one column to be in "text" format.

    Is that possible with Excel?

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,417

    Re: Export to text file keeping text format for one column

    No. Format information does not exist in a .txt file. All data is written as text to a .txt file anyway, so it's not clear what you need to accomplish.

    If you explain why you want that, we might be able to meet your ultimate goal.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    10-25-2017
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    2

    Re: Export to text file keeping text format for one column

    I am working with a program written for Access (runtime version), but I no longer have Access. So I'm trying to clean up the data base with what the program can export and import.
    When it exports backup files (as cvs), the titles in the first row and one column are in text format (with" ") around them. And it must be in that form for the import function to work.

    I was hoping to use excel for the work since I can easily sort the data and eliminate a lot of trash. Then import the back up file into the main program.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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