splitting 1 column of data into multiple columns

C

CiceroCF

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
 
D

Dave Peterson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

spliting a column of data into multiple columns 7
Page numbering with Merged Document and IF statements 1
Sort by placement value from left to right & adding trailing zeros for short 3
Unhide column difficulty 3
IF ARRAY with multiple conditions. 1
Append multiple columns 2
append multiple columns 2
Exporting to text file in multiple lines 3

Top