Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing csv data (with semicolons) into excel
Anyone have any way to import a csv file that is separated by semi-colons
into a spreadsheet? I am hoping i can take the file and parse it out by the semicolons and use the top line as the heading line (titles). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing csv data (with semicolons) into excel
http://www.cpearson.com/excel/imptext.htm import/export text files
Chip Pearson's site. -- Regards, Tom Ogilvy "markshunter" wrote: Anyone have any way to import a csv file that is separated by semi-colons into a spreadsheet? I am hoping i can take the file and parse it out by the semicolons and use the top line as the heading line (titles). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing csv data (with semicolons) into excel
Thanks Tom. I got this to work. I guess there is no "Automatic" way to get
this to work (ie hands off) "Tom Ogilvy" wrote: http://www.cpearson.com/excel/imptext.htm import/export text files Chip Pearson's site. -- Regards, Tom Ogilvy "markshunter" wrote: Anyone have any way to import a csv file that is separated by semi-colons into a spreadsheet? I am hoping i can take the file and parse it out by the semicolons and use the top line as the heading line (titles). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing csv data (with semicolons) into excel
If you have xl2002 or xl2003, there is an international tab in
tools=options, but I only saw settings for decimal separator and thousands separator. In international setting in the control panel, there is a setting for list separator. but changing that changes it for all windows applications. This all assumes you tried just opening the file in Excel and it didn't work as you wanted. -- Regards, Tom Ogilvy "markshunter" wrote: Thanks Tom. I got this to work. I guess there is no "Automatic" way to get this to work (ie hands off) "Tom Ogilvy" wrote: http://www.cpearson.com/excel/imptext.htm import/export text files Chip Pearson's site. -- Regards, Tom Ogilvy "markshunter" wrote: Anyone have any way to import a csv file that is separated by semi-colons into a spreadsheet? I am hoping i can take the file and parse it out by the semicolons and use the top line as the heading line (titles). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data Into Excel | Excel Worksheet Functions | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data into excel | Excel Worksheet Functions | |||
Removing semicolons | Excel Programming | |||
Removing semicolons | Excel Programming |