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

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

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

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

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