Spliting 1 Text field into 3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use Data | Text to Columns... using the comma as a separator

Regards

Trevor
 
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)
 
Thank-you John, worked!



john the confused said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Data from One Worksheet to Many Automatically 3
Split data in field on character return 0
Spliting a cell 3
Seperating information in a cell 1
Too Clever... 2
Spliting a cell into two parts 2
Spliting a number with leading zeros 7
How to split a cell into 3 columns 2

Back
Top