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!
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!
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.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks