| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting text in one column into multiple columns
I have a workbook of date that I need to convert into a Pivot table/chart.
However, the headings that I need to sort on are all listed in column A. I need to split this column into multiple columns for sorting purposes. Each text stream in column A is starts with a "xxxxx :" ...where xxxx is 'resource', 'project', 'task', 'phase', 'activity'. Any ideas would be greatly appreciated. Here is a sample of the column.... Resource: Alex S 1 FTE Project: Genesis Task: Test Director Setup Project: Rating Task: Delivery Project: Statistical Plan Phase: Execution Phase Project: Claims Activity: Initiate / Plan / Execute / Closeout |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Text from single cell in column across multiple Columns | Excel Worksheet Functions | |||
| Splitting one column into multiple columns | Excel Worksheet Functions | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
| Splitting text in one column into two (or more) columns. | Excel Worksheet Functions | |||
| splitting text to multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
