| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text file data all in first column
Trying to import my text file into Query. Asks me to select columns, but all
the data is in first column, how do I create the text file from the back office so it will put records in seperate columns. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text file data all in first column
Look at Data==Text-to-Columns
"Hood" wrote: Trying to import my text file into Query. Asks me to select columns, but all the data is in first column, how do I create the text file from the back office so it will put records in seperate columns. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text file data all in first column
I know text to columns but the reason for using query on text files is that
the text files contain more rows of data than Excel can handle, therefore I cannot manipulate data within Excel. The answer is probably going to be in how my back office creates a text file, this is my area of knowledge deficiency (AOKD). "Toppers" wrote: Look at Data==Text-to-Columns "Hood" wrote: Trying to import my text file into Query. Asks me to select columns, but all the data is in first column, how do I create the text file from the back office so it will put records in seperate columns. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want a column of cells to have drop down box of another text file | Excel Discussion (Misc queries) | |||
| Help...Need to modify data within a column in a .csv file | Excel Discussion (Misc queries) | |||
| Help...Need to modify data within a column in a .csv file | Excel Worksheet Functions | |||
| When I open a *.CSV file, text appear in the first column? What c. | Setting up and Configuration of Excel | |||
| Can delimited text file imports be extracted to a single column i. | Excel Discussion (Misc queries) | |||
Linear Mode
