How can I do this in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Just Me - 25 Jan 2007 15:32 GMT

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

Reply to this Message

Scott - 25 Jan 2007 15:56 GMT

The feature is Data -> Text to Columns.

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

Scott

> I know only enough about Excel to get me in trouble so please keep your
> answers as basic as possible.
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Pete_UK - 25 Jan 2007 16:00 GMT

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

> I know only enough about Excel to get me in trouble so please keep your
> answers as basic as possible.
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Rate this thread: