+ Reply to Thread
Results 1 to 5 of 5

Comma Delimited .txt file

  1. #1
    Registered User
    Join Date
    03-24-2008
    Posts
    2

    Comma Delimited .txt file

    I have some software that asks for a .txt file to be comma delimited like this:

    "name", "address", etc.
    "joe", "1234 st", etc.

    but it wont uploade a .csv only a .txt. So my question is how can I make excel do that and have it be a .txt instead of a .csv. Is that possible?

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    Try something like this :

    Please Login or Register  to view this content.
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

  3. #3
    Registered User
    Join Date
    03-24-2008
    Posts
    2
    thank you for the help. This may sound dumb, but Im not sure where to put code like that, can you tell me?

    Also, Im not sure if I was all that clear about my issue; Ill try to clarify. I have a spread sheet on an excel worksheet with 1000s of records on it, and that is what I am trying to turn into a .txt file in the "", "" format.
    Thanks

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    Save as .csv and open in Notepad or Wordpad, then save as a text file.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello wshiwsbrding,

    In order to automate your task, it would help to know what program created the spreadsheet or which application is linked to.

    Sincerely,
    Leith Ross

+ 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