splitting 1 column of data into multiple columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CiceroCF - 25 Mar 2005 00:17 GMT

I am trying to split up some data into multiple columns with part of the data
in each column... ie: 02-34-5-M is currently in one column... i need it
split into 4 columns as the following....
02 34 5 M
01 256 0 Q
7 45 4 T
This needs to be done so I can sort by using the 2nd set of numbers.
Thanks in advance for your help.
Carl

Reply to this Message

Dave Peterson - 25 Mar 2005 02:50 GMT

Select that column and do Data|Text to columns.

I'm not sure if you want the fields with numbers as Text or Numbers (General).

And make sure you have some empty columns to the right!

> I am trying to split up some data into multiple columns with part of the data
> in each column... ie: 02-34-5-M is currently in one column... i need it
[quoted text clipped - 5 lines]
> Thanks in advance for your help.
> Carl

Signature

Dave Peterson

Reply to this Message

Rate this thread: