+ 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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,719

    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.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/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)

Similar Threads

  1. [SOLVED] Export specific range to text file and import the text file if needed
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 07:38 AM
  2. [SOLVED] Format align text in column when export to excel with VBA
    By Cuong Pham in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 12:11 AM
  3. Export Each Column on Worksheet as Text File
    By ruezo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-26-2012, 11:33 AM
  4. [SOLVED] format sheet info then export to text file
    By dalerdd in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-15-2012, 12:58 PM
  5. Export a text File in to an excel and format it
    By Aashiq_ilahi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2012, 06:22 AM
  6. Export to text file in custom row format
    By fredo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2011, 01:48 AM
  7. [SOLVED] How to make text data export to excel in text format.
    By ~@%.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2006, 11:20 PM

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