Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting 1 Text field into 3
Help!
I currently export a task file from MSP to Excel which contains mulitple resources (comma seperated) in one field. Once I get the data to Excel I need to be able to split the values up. Is there a formula which allows me to split them up into 3 seperate fields? I use the data in pivot tables and then can't filter on any specific individual. Any help appreciated Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting 1 Text field into 3
Use Data | Text to Columns... using the comma as a separator
Regards Trevor "Janet BN" wrote in message ... Help! I currently export a task file from MSP to Excel which contains mulitple resources (comma seperated) in one field. Once I get the data to Excel I need to be able to split the values up. Is there a formula which allows me to split them up into 3 seperate fields? I use the data in pivot tables and then can't filter on any specific individual. Any help appreciated Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting 1 Text field into 3
Have a look at text to columns in the data menu and follow the onscreen
instructons -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Janet BN" wrote: Help! I currently export a task file from MSP to Excel which contains mulitple resources (comma seperated) in one field. Once I get the data to Excel I need to be able to split the values up. Is there a formula which allows me to split them up into 3 seperate fields? I use the data in pivot tables and then can't filter on any specific individual. Any help appreciated Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting 1 Text field into 3
Thank-you Trevor, worked! I had obviously over thought the problem.
"Trevor Shuttleworth" wrote: Use Data | Text to Columns... using the comma as a separator Regards Trevor "Janet BN" wrote in message ... Help! I currently export a task file from MSP to Excel which contains mulitple resources (comma seperated) in one field. Once I get the data to Excel I need to be able to split the values up. Is there a formula which allows me to split them up into 3 seperate fields? I use the data in pivot tables and then can't filter on any specific individual. Any help appreciated Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting 1 Text field into 3
Thank-you John, worked!
"john the confused" wrote: Have a look at text to columns in the data menu and follow the onscreen instructons -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Janet BN" wrote: Help! I currently export a task file from MSP to Excel which contains mulitple resources (comma seperated) in one field. Once I get the data to Excel I need to be able to split the values up. Is there a formula which allows me to split them up into 3 seperate fields? I use the data in pivot tables and then can't filter on any specific individual. Any help appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
import excel to Access has a problem with text field | Excel Worksheet Functions | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) | |||
preserve "-" when importing text field from access | Excel Worksheet Functions |