LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
import excel to Access has a problem with text field ABCBAC Excel Worksheet Functions 0 November 11th 06 08:09 AM
Copy from a Cell to a text box. AJL Excel Worksheet Functions 9 November 7th 06 04:58 PM
Some lines of text in Excel field do not wrap text. Please help. Michele Excel Discussion (Misc queries) 0 January 5th 06 07:27 PM
preserve "-" when importing text field from access rfctkl Excel Worksheet Functions 1 September 9th 05 11:05 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"