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
|