Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
maggie Hettinger
 
Posts: n/a
Default text import all in one column. how do I set it to multiple column

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   Report Post  
Posted to microsoft.public.excel.newusers
Kevin B
 
Posts: n/a
Default text import all in one column. how do I set it to multiple column

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   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default text import all in one column. how do I set it to multiple column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet Aster Excel Worksheet Functions 3 March 12th 06 09:58 AM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
Creating multiple hyperlinks from a column where the text in the . OzGhostRiding Excel Worksheet Functions 5 December 14th 04 01:45 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"