How can I do this in Excel

  • Thread starter Thread starter Just Me
  • Start date Start date
J

Just Me

I know only enough about Excel to get me in trouble so please keep your
answers as basic as possible.

I have a entry like 01/04/2006 10 23 42 48 54 03 x4

when I paste this into a worksheet I would like it to appear like this

col A col B col C col D col E
col F col G col H
01/04/2006 10 23 42 48
54 03 x4


Can this be done? I remember seeing a feature where you could put lines to
sperate date into different columns

Thanks
 
The feature is Data -> Text to Columns.

Select Delimited.
Specify that you want the [space] to be your separator, and then
continue.

Scott
 
Is the data all in one cell? If so, you can highlight the cells
containing the data and use Data | Text-to-Columns. This will bring up
a Wizard with three steps - on the first step ensure that "Delimited"
is checked, on the second step specify space as the delimiter, and on
the 3rd step you can specify if you want the data to go into a
different column (or overwrite the current data),and you can also
specify to treat the first column of data as a date - not sure from
your example if it is MDY or DMY format, but you can select the
appropriate one.

Hope this helps.

Pete
 
Back
Top