Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Txt file into Excel
When I import a .txt file into excel all of the data is displayed in one row.
How do I get excel to put the data into the proper rows? I just open the .txt file and the import wizard opens. The data is delimited by commas. Sorting the data into columns seems to work fine. Unfortunately, the data just displays in the first row in different columns. It does not seem to recognize when the new row should start. The column that contains the data where the new row should start has the data from the last column of the previous row in it as well, example: $1,337.52"01-Jan-2008 The $1,337.52 should be the last cell in the row and the 01-Jan-2008 should be the first cell of the next row. Instead they are in the same cell. Therefore, the entire set of data is all in one row! I am not very experienced and would appreciate any help. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing a txt file into Excel - | Excel Discussion (Misc queries) | |||
Importing VBA file into Excel | Excel Programming | |||
importing a csv file into Excel | Excel Programming | |||
Importing .pdf file into Excel | Excel Discussion (Misc queries) | |||
Importing CSV file into Excel | Excel Programming |