| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
splitting 1 column of data into multiple columns
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 |
|
#2
|
|||
|
|||
|
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! CiceroCF wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Occurance of data in multiple columns | Excel Worksheet Functions | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Data from a number of rows and columns to one column | Excel Discussion (Misc queries) | |||
| How do I link columns so data flows from 1 column to another like. | Excel Discussion (Misc queries) | |||
Linear Mode
