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 |
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 |