|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
02-04-2009, 03:14 AM
|
#1 (permalink) |
|
Registered User
Join Date: Feb 2009
Posts: 2
OS: Windows XP
|
EXCEL How do I order csv data into columns?
Hi
I have exported data from our software package into a csv document. However, all the data is squished into column A and separated by commas. I would like to separate the data into separate columns. Does anyone know how I can do this?? thanks Nicole |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
02-04-2009, 07:17 AM
|
#2 (permalink) |
|
Registered User
Join Date: Feb 2009
Posts: 3
OS: Windows XP & Vista
|
Re: EXCEL How do I order csv data into columns?
Try this...
Open Excel. Go to File --> Open. Search for the csv file, 'change file of type' to 'all files' if necessary. When you select the file and open it, you should run the text import wizard. Select Delimited and Next Change the delimiters to Comma and Next. Click finish. If it still doesn't work, open the csv file into NotePad. Save as a different file name and then run through this procedure Last edited by simjambra; 02-04-2009 at 07:18 AM. |
|
|
|
|
| Thread Tools | |
|
|
