1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Export as comma delimited (Excel to Wordpad)

Discussion in 'Business Applications' started by slyvone, Apr 27, 2006.

Thread Status:
Not open for further replies.
  1. slyvone

    slyvone Thread Starter

    Joined:
    Oct 14, 2005
    Messages:
    30
    Hi again, probably an easy one.

    I would like to export Excel data to a text file so that the text file is exported with both quotation marks and commas as delimiters.

    Microsoft support page returns a relevant article but offers no answer.

    Thank you
     
  2. coachdan32

    coachdan32

    Joined:
    Nov 13, 2003
    Messages:
    1,021
    This is what I found in the help file for exporting to text file:

    Convert bidirectional text files to ANSI
    Language-specific information

    The ConvText utility provides more support (additional code pages and visual text layout options) than the Microsoft Excel Text Import Wizard for converting right-to-left characters in bidirectional files to ANSI characters with logical text layout. ConvText is installed as part of Excel.

    In the \Program Files\Microsoft Office\Office folder, double-click the ConvText.exe icon.


    Click Convert To Windows ANSI Code Page.


    Type file names in the Source and Target boxes, or click Browse.


    Select the code page, text layout, file type, and file type parameters that match the source text file you are converting.


    Click Load. You can also click Save to retain the conversion specifications.


    Click Convert.


    Follow the instructions in the Text Import Wizard.
    All field names and records from the original worksheet are fully recreated in a new worksheet.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/462888

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice