+ Reply to Thread
Results 1 to 2 of 2

Question about Delineating Commas Automatically without a Macro

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    USA
    MS-Off Ver
    2011
    Posts
    3

    Question about Delineating Commas Automatically without a Macro

    Hello all!


    I am trying to find a way to import data from a .CSV file into Excel and have the columns automatically delineated by comma. I would prefer to avoid using a macro here. Thanks in advance for your help!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Question about Delineating Commas Automatically without a Macro

    It seems so simple, that I wonder if there is more to your question.

    If your Window's system settings are set for commas as separator, the File-Open command should open a CSV file and correctly parse the file using the commas as delimiters.

    In cases where that doesn't work correctly, change the file extension to .txt, then use the File->Open command on the file. Excel should bring up the "Text Import Wizard" which will allow you to set the needed options for parsing the file.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Macro to insert rows using commas
    By Revathi kannan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-21-2015, 08:31 PM
  2. Replies: 5
    Last Post: 01-17-2014, 05:56 PM
  3. [SOLVED] Automatically punctuate a formula that lists text with commas and, fullstop.
    By ddee in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-27-2013, 11:09 AM
  4. [SOLVED] Macro deleting commas
    By mike02 in forum Excel General
    Replies: 7
    Last Post: 08-14-2012, 03:11 PM
  5. Specific sorting question involving commas
    By Geoff1184 in forum Excel General
    Replies: 4
    Last Post: 06-23-2009, 02:50 PM
  6. Macro question - need to automatically find and replace multiple content
    By rodeman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2008, 06:26 PM
  7. Replacing dots with commas using macro
    By maxest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2006, 11:35 AM

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