Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm trying to import data. I want it to go across into nine columns, but
it's just loading in as one column. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
After you import the text you can use the Text to Columns function on the
DATA menu to parse data across columns. -- Kevin Backmann "maggie Hettinger" wrote: I'm trying to import data. I want it to go across into nine columns, but it's just loading in as one column. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
First, make sure there are nine empty columns to the right of your column
with the data in it.........then highlight the column, and do Data TextToColumns Delimited and set "space" as the delimiter........practice with a copy of your data, not the original. You may find that during this process it will be advantageous to follow the menus and format certain of the columns according to their data type. Once you do it a few times, it will come easy...... hth Vaya con Dios, Chuck, CABGx3 "maggie Hettinger" wrote: I'm trying to import data. I want it to go across into nine columns, but it's just loading in as one column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Creating multiple hyperlinks from a column where the text in the . | Excel Worksheet Functions |