| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import a CSV file to excel
I have a csv file seperated by a ; in a notepad. one line has 10 bits of data, there are upto 40 lines or records. I want to import the data to excel, when I use the Data/Import wizard, it places each record within the notepad to one column, how do I get it to split the data within each of the ; into a seperate column, using one row for each record. Lorraine -- lorraine knight ------------------------------------------------------------------------ lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294 View this thread: http://www.excelforum.com/showthread...hreadid=557321 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import flash file in excel | Excel Discussion (Misc queries) | |||
| how to import more than 1 text file into the same Excel worksheet. | Excel Discussion (Misc queries) | |||
| Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
| I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
| How can I import a text file into excel with each field as a sepe. | Excel Discussion (Misc queries) | |||
Threaded Mode
