If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to seperate into columns?
Hope someone can help me. I have a text file that when I open in Excel, all the comma delimited fields are in the "A" column. I need all these records to be in different columns. Here is an example: DATE,"TIME","ID","FNAME","LNAME","SUFFIX","TITLE", "COMPANY","ADDRESS1","ADDRESS2","CITY","ST","COUNT RY","ZIP_CODE","PHONE","FAX","CODES","EMAIL I appreciate any help. -- bufhal ------------------------------------------------------------------------ bufhal's Profile: http://www.excelforum.com/member.php...o&userid=10702 View this thread: http://www.excelforum.com/showthread...hreadid=501695 |
#2
|
|||
|
|||
how to seperate into columns?
highlight the cell you want to break up. Click Data-Text to Columns.
Choose Delimited and select next. Choose comma, and hit finish. "bufhal" wrote: Hope someone can help me. I have a text file that when I open in Excel, all the comma delimited fields are in the "A" column. I need all these records to be in different columns. Here is an example: DATE,"TIME","ID","FNAME","LNAME","SUFFIX","TITLE", "COMPANY","ADDRESS1","ADDRESS2","CITY","ST","COUNT RY","ZIP_CODE","PHONE","FAX","CODES","EMAIL I appreciate any help. -- bufhal ------------------------------------------------------------------------ bufhal's Profile: http://www.excelforum.com/member.php...o&userid=10702 View this thread: http://www.excelforum.com/showthread...hreadid=501695 |
#3
|
|||
|
|||
how to seperate into columns?
If you open a blank spreadsheet, and then go to the data menu and choose to
import external data, You can find that file that you want to import. Then, there is a wizard that will come up. One of the screens in that wizard asks what the delimator is. That is where you choose the comma. Right now, it looks as though it doesn't know that the comma is supposed to make it skip to the next cell. "bufhal" wrote: Hope someone can help me. I have a text file that when I open in Excel, all the comma delimited fields are in the "A" column. I need all these records to be in different columns. Here is an example: DATE,"TIME","ID","FNAME","LNAME","SUFFIX","TITLE", "COMPANY","ADDRESS1","ADDRESS2","CITY","ST","COUNT RY","ZIP_CODE","PHONE","FAX","CODES","EMAIL I appreciate any help. -- bufhal ------------------------------------------------------------------------ bufhal's Profile: http://www.excelforum.com/member.php...o&userid=10702 View this thread: http://www.excelforum.com/showthread...hreadid=501695 |
#4
|
|||
|
|||
how to seperate into columns?
thank you... -- bufhal ------------------------------------------------------------------------ bufhal's Profile: http://www.excelforum.com/member.php...o&userid=10702 View this thread: http://www.excelforum.com/showthread...hreadid=501695 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing Only Certain Columns of Text Files into Access | [email protected] | General Discussion | 2 | October 4th, 2005 08:46 PM |
comparing 2 similar columns on seperate work sheets in 1 workbook | Dan | General Discussion | 4 | September 20th, 2005 11:58 PM |
Excel columns problem | Charlie Johnson | General Discussion | 4 | October 12th, 2004 04:40 PM |
creating matching data in different columns | Tig | General Discussion | 6 | August 13th, 2004 04:26 AM |
seperate block of data to different columns | }}¥J | Worksheet Functions | 2 | April 24th, 2004 03:53 PM |