| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comma Deleted File into Excel doc
I have recieved a comma deleted file which I need to save as an excel
doc. Having opened it with excel all the data in shown in the first column. There are several columns of info. I have tried to format the text to no avail. Line Example, 3040, 3040, -1, -1, -1 How can I get this into 5 columns instead of one. Thanks in advance. Mark |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comma Deleted File into Excel doc
Hi,
Try Data-Import External Data- Import Data Follow the wizard, and as delimiter char set comma "," It should help ! Br, Andis "MarkAC" wrote in message oups.com... I have recieved a comma deleted file which I need to save as an excel doc. Having opened it with excel all the data in shown in the first column. There are several columns of info. I have tried to format the text to no avail. Line Example, 3040, 3040, -1, -1, -1 How can I get this into 5 columns instead of one. Thanks in advance. Mark |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comma Deleted File into Excel doc
you can even use text to columns options under "data" menu.
"Andis Cirulis" wrote: Hi, Try Data-Import External Data- Import Data Follow the wizard, and as delimiter char set comma "," It should help ! Br, Andis "MarkAC" wrote in message oups.com... I have recieved a comma deleted file which I need to save as an excel doc. Having opened it with excel all the data in shown in the first column. There are several columns of info. I have tried to format the text to no avail. Line Example, 3040, 3040, -1, -1, -1 How can I get this into 5 columns instead of one. Thanks in advance. Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Preventing an excel file from being deleted by another user | Excel Discussion (Misc queries) | |||
| Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Linear Mode
